https://pim.vivog.fr/en/pg/126/business-issues

Query Metrics

8 Database Queries
7 Different statements
1.90 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
0.34 ms
(17.68%)
1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.final_price AS final_price_3, t0.total_price AS total_price_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8 FROM carts_items t0 WHERE t0.cart_id = ?
Parameters:
[
  36949
]
0.29 ms
(15.32%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[]
0.29 ms
(15.27%)
1
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.id = ?
Parameters:
[
  36949
]
0.26 ms
(13.79%)
1
SELECT t0.id AS id_1, t0.pages_title AS pages_title_2, t0.pages_meta_title AS pages_meta_title_3, t0.pages_meta_keywords AS pages_meta_keywords_4, t0.pages_meta_description AS pages_meta_description_5, t0.pages_blurb AS pages_blurb_6, t0.pages_body AS pages_body_7, t0.pages_url AS pages_url_8, t0.pages_id AS pages_id_9, t0.language_id AS language_id_10 FROM pages_description t0 WHERE t0.pages_id = ?
Parameters:
[
  126
]
0.25 ms
(13.21%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
0.24 ms
(12.52%)
1
SELECT t0.pages_id AS pages_id_1, t0.pages_image AS pages_image_2, t0.pages_date_added AS pages_date_added_3, t0.pages_date_modified AS pages_date_modified_4, t0.pages_author AS pages_author_5, t0.pages_status AS pages_status_6, t0.pages_sort_order AS pages_sort_order_7, t0.price_group_id AS price_group_id_8 FROM pages t0 WHERE t0.pages_id = ?
Parameters:
[
  "126"
]
0.23 ms
(12.21%)
2
SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.languages_id = ?
Parameters:
[
  4
]

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.