Query Metrics
64
Database Queries
4
Different statements
9.29 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.66 ms (82.40%) |
61 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "boutique-produit" "de" ] |
0.67 ms (7.19%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.slug AS slug_3, t0.type AS type_4, t0.tags AS tags_5, t0.name AS name_6, t0.usecase AS usecase_7, t0.description AS description_8, t0.additional AS additional_9, t0.attributes AS attributes_10, t0.price AS price_11, t0.amount_show AS amount_show_12, t0.published AS published_13, t0.pinned AS pinned_14, t0.slider AS slider_15, t0.featured AS featured_16, t0.stock AS stock_17, t0.stock_total AS stock_total_18, t0.stock_left AS stock_left_19, t0.weight AS weight_20, t0.packaging AS packaging_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.dataform AS dataform_24, t0.category_id AS category_id_25, t26.id AS id_27, t26.position AS position_28, t26.slug AS slug_29, t26.tags AS tags_30, t26.name AS name_31, t26.description AS description_32, t26.published AS published_33, t26.pinned AS pinned_34, t26.slider AS slider_35, t26.featured AS featured_36, t26.created_at AS created_at_37, t26.updated_at AS updated_at_38, t26.dataform AS dataform_39 FROM framework_shop_product t0 LEFT JOIN framework_shop_category t26 ON t0.category_id = t26.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
"bon-cadeau-16"
]
|
0.62 ms (6.67%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM framework_translation t0
Parameters:
[] |
0.35 ms (3.74%) |
1 |
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.slug AS slug_2, f0_.type AS type_3, f0_.tags AS tags_4, f0_.name AS name_5, f0_.usecase AS usecase_6, f0_.description AS description_7, f0_.additional AS additional_8, f0_.attributes AS attributes_9, f0_.price AS price_10, f0_.amount_show AS amount_show_11, f0_.published AS published_12, f0_.pinned AS pinned_13, f0_.slider AS slider_14, f0_.featured AS featured_15, f0_.stock AS stock_16, f0_.stock_total AS stock_total_17, f0_.stock_left AS stock_left_18, f0_.weight AS weight_19, f0_.packaging AS packaging_20, f0_.created_at AS created_at_21, f0_.updated_at AS updated_at_22, f0_.dataform AS dataform_23, f0_.category_id AS category_id_24 FROM framework_shop_product f0_ WHERE f0_.tags LIKE ? OR f0_.tags LIKE ? ORDER BY f0_.position ASC
Parameters:
[ "%bon%" "%cadeau%" ] |
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 |
---|---|
App\Framework\AppBundle\Entity\Page | No errors. |
App\Framework\ShopBundle\Entity\Product | No errors. |
App\Framework\ShopBundle\Entity\Category | No errors. |
App\Framework\AppBundle\Entity\Translation | No errors. |