Query Metrics
75
Database Queries
6
Different statements
10.13 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.49 ms (83.82%) |
70 |
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-articles" "en" ] |
0.69 ms (6.79%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t5.id AS id_6, t5.username AS username_7, t5.email AS email_8, t5.password AS password_9, t5.forgot AS forgot_10, t5.roles AS roles_11, t5.infos AS infos_12, t5.created_at AS created_at_13, t5.updated_at AS updated_at_14, t5.logged_at AS logged_at_15, t5.deleted AS deleted_16, t5.email_recap AS email_recap_17, t0.product_id AS product_id_18, t19.id AS id_20, t19.position AS position_21, t19.slug AS slug_22, t19.type AS type_23, t19.tags AS tags_24, t19.name AS name_25, t19.usecase AS usecase_26, t19.description AS description_27, t19.additional AS additional_28, t19.attributes AS attributes_29, t19.price AS price_30, t19.amount_show AS amount_show_31, t19.published AS published_32, t19.pinned AS pinned_33, t19.slider AS slider_34, t19.featured AS featured_35, t19.stock AS stock_36, t19.stock_total AS stock_total_37, t19.stock_left AS stock_left_38, t19.weight AS weight_39, t19.packaging AS packaging_40, t19.created_at AS created_at_41, t19.updated_at AS updated_at_42, t19.dataform AS dataform_43, t19.category_id AS category_id_44 FROM framework_shop_bookmark t0 LEFT JOIN framework_user t5 ON t0.user_id = t5.id LEFT JOIN framework_shop_product t19 ON t0.product_id = t19.id WHERE t0.user_id IS NULL AND t0.product_id IN (?)
Parameters:
[ [ 11 12 18 29 30 5 19 22 9 20 23 31 10 21 13 24 14 25 15 26 16 27 17 28 ] ] |
0.41 ms (4.04%) |
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.22 ms (2.18%) |
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.category_id = ? ORDER BY t0.position ASC
Parameters:
[
5
]
|
0.18 ms (1.82%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.slug AS slug_3, t0.tags AS tags_4, t0.name AS name_5, t0.description AS description_6, t0.published AS published_7, t0.pinned AS pinned_8, t0.slider AS slider_9, t0.featured AS featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.dataform AS dataform_13 FROM framework_shop_category t0 ORDER BY t0.position ASC
Parameters:
[] |
0.14 ms (1.35%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.slug AS slug_3, t0.tags AS tags_4, t0.name AS name_5, t0.description AS description_6, t0.published AS published_7, t0.pinned AS pinned_8, t0.slider AS slider_9, t0.featured AS featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.dataform AS dataform_13 FROM framework_shop_category t0 WHERE t0.slug IS NULL LIMIT 1
Parameters:
[] |
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\Category | No errors. |
App\Framework\ShopBundle\Entity\Product | No errors. |
App\Framework\ShopBundle\Entity\Bookmark | No errors. |
App\Framework\AppBundle\Entity\User | No errors. |
App\Framework\AppBundle\Entity\Translation | No errors. |