Query Metrics
4
Database Queries
4
Different statements
2.84 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.12 ms |
SELECT c0_.id AS id_0, c0_.layout AS layout_1, c0_.serialized_layout AS serialized_layout_2, c0_.time_last_updated AS time_last_updated_3, c0_.synchronize_translations AS synchronize_translations_4, c0_.type AS type_5, c0_.parent_id AS parent_id_6, c0_.primary_image_id AS primary_image_id_7 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.page_id WHERE c1_.locale = ? AND c1_.permalink = ? AND c0_.parent_id IS NULL LIMIT 1
Parameters:
[ "en" "blog" ] |
2 | 0.70 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.permalink AS permalink_4, t0.category_id AS category_id_5 FROM shop_category_translation t0 WHERE t0.permalink = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "blog" "en" ] |
3 | 0.55 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.permalink AS permalink_4, t0.description AS description_5, t0.product_id AS product_id_6 FROM shop_product_translation t0 WHERE t0.permalink = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "blog" "en" ] |
4 | 0.46 ms |
SELECT j0_.id AS id_0, j0_.min_hours AS min_hours_1, j0_.max_hours AS max_hours_2, j0_.sort_order AS sort_order_3, j0_.enabled AS enabled_4 FROM jobs_job_offer j0_ LEFT JOIN jobs_job_offer_translation j1_ ON j0_.id = j1_.job_offer_id WHERE j1_.locale = ? AND j1_.permalink = ? AND j0_.enabled = 1 LIMIT 1
Parameters:
[ "en" "blog" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
Boldr\Cms\CmsBundle\Entity\Page | No errors. |
Boldr\Cms\CmsBundle\Entity\Translation | No errors. |
Boldr\Cms\CmsBundle\Entity\PageTranslation | No errors. |
Boldr\Cms\CmsBundle\Entity\Upload | No errors. |
Boldr\Shop\ShopBundle\Entity\CategoryTranslation | No errors. |
Boldr\Shop\ShopBundle\Entity\Category | No errors. |
Boldr\Shop\ShopBundle\Entity\ProductTranslation | No errors. |
Boldr\Shop\ShopBundle\Entity\Product | No errors. |
Boldr\Cms\JobsBundle\Entity\JobOffer | No errors. |
Boldr\Cms\JobsBundle\Entity\JobOfferTranslation | No errors. |