Query Metrics

8 Database Queries
6 Different statements
2.41 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.75 ms
(31.24%)
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:
[
  "70"
]
0.44 ms
(18.36%)
2
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.33 ms
(13.73%)
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:
[
  24347
]
0.32 ms
(13.44%)
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:
[
  24347
]
0.29 ms
(12.23%)
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:
[
  70
]
0.27 ms
(11.00%)
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:
[
  1
]

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\Entity\Page No errors.
App\Entity\PriceGroup No errors.
App\Entity\PageDescription No errors.
App\Entity\Language No errors.
App\Entity\Cart No errors.
App\Entity\Customer No errors.
App\Entity\Address No errors.
App\Entity\Carrier No errors.
App\Entity\PaymentMean No errors.
App\Entity\CartItem No errors.
App\Entity\Product No errors.