GET https://www.dev.mazykkavinyles.fr/mes-commandes/detail/214

Query Metrics

6 Database Queries
6 Different statements
13.14 ms Query time
0 Invalid entities
14 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.11 ms
(23.65%)
1
SELECT t0.id AS id_4, t0.ref AS ref_5, t0.designation AS designation_6, t0.created_at AS created_at_7, t0.price AS price_8, t0.updated_at AS updated_at_9, t0.promo AS promo_10, t0.description AS description_11, t0.slug AS slug_12, t0.quantity AS quantity_13, t0.weight AS weight_14, t0.category_id AS category_id_15, t0.category, t1.format AS format_16, t1.year AS year_17, t1.state AS state_18, t1.img AS img_19, t1.nb_items AS nb_items_20, t1.label_id AS label_id_21, t2.year AS year_22, t2.state AS state_23, t2.label_id AS label_id_24, t3.state AS state_25, t3.img AS img_26 FROM product t0 LEFT JOIN vinyl t1 ON t0.id = t1.id LEFT JOIN cd t2 ON t0.id = t2.id LEFT JOIN accessory t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
  229
]
3.04 ms
(23.17%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.is_activ AS is_activ_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.connected_at AS connected_at_9, t0.is_verified AS is_verified_10, t0.signature AS signature_11, t0.phone AS phone_12, t13.id AS id_14, t13.address AS address_15, t13.postal_code AS postal_code_16, t13.city AS city_17, t13.country AS country_18, t13.complement AS complement_19, t13.uid_id AS uid_id_20, t21.id AS id_22, t21.items AS items_23, t21.updated_at AS updated_at_24, t21.customer_id AS customer_id_25 FROM uid t0 LEFT JOIN address t13 ON t13.uid_id = t0.id LEFT JOIN cart t21 ON t21.customer_id = t0.id WHERE t0.id = ?
Parameters:
[
  6
]
2.60 ms
(19.81%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.ht_amount AS ht_amount_3, t0.amount AS amount_4, t0.ht_shipping AS ht_shipping_5, t0.shipping AS shipping_6, t0.pi AS pi_7, t0.state AS state_8, t0.ref AS ref_9, t0.address AS address_10, t0.tax AS tax_11, t0.user_id AS user_id_12, t0.livreur_id AS livreur_id_13, t14.id AS id_15, t14.created_at AS created_at_16, t14.total AS total_17, t14.tax AS tax_18, t14.ordered_id AS ordered_id_19, t0.linked_to_id AS linked_to_id_20, t21.id AS id_22, t21.tracking_number AS tracking_number_23, t21.label_url AS label_url_24, t21.created_at AS created_at_25, t21.order_id AS order_id_26, t21.livreur_id AS livreur_id_27 FROM `order` t0 LEFT JOIN invoice t14 ON t14.ordered_id = t0.id LEFT JOIN shipment t21 ON t21.order_id = t0.id WHERE t0.id = ?
Parameters:
[
  214
]
1.61 ms
(12.22%)
1
SELECT t0.id AS id_1, t0.ht_price AS ht_price_2, t0.price AS price_3, t0.qty AS qty_4, t0.order_id_id AS order_id_id_5, t0.product_id AS product_id_6 FROM detail t0 WHERE t0.order_id_id = ?
Parameters:
[
  214
]
1.46 ms
(11.11%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM livreur t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.32 ms
(10.03%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5 FROM params t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Params 4
App\Entity\Uid 1
App\Entity\Address 1
App\Entity\Cart 1
App\Entity\Order 1
App\Entity\Livreur 1
App\Entity\Invoice 1
App\Entity\Shipment 1
App\Entity\Detail 1
App\Entity\Product 1
App\Entity\Category 1

Entities Mapping

Class Mapping errors
App\Entity\Uid No errors.
App\Entity\Address No errors.
App\Entity\Cart No errors.
App\Entity\Order No errors.
App\Entity\Livreur No errors.
App\Entity\Invoice No errors.
App\Entity\Shipment No errors.
App\Entity\Detail No errors.
App\Entity\Livraison No errors.
App\Entity\Delivery No errors.
App\Entity\Params No errors.
App\Entity\Product No errors.
App\Entity\Vinyl No errors.
App\Entity\Cd No errors.
App\Entity\Accessory No errors.
App\Entity\Category No errors.
App\Entity\Label No errors.
App\Entity\Promote No errors.