Query Metrics
2
Database Queries
2
Different statements
6.22 ms
Query time
0
Invalid entities
6
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.82 ms (61.50%) |
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:
[
"209"
]
|
|
2.39 ms (38.50%) |
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 WHERE t0.name = ? LIMIT 1
Parameters:
[
"fr_vat"
]
|
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 | 1 |
| App\Entity\Order | 1 |
| App\Entity\Uid | 1 |
| App\Entity\Livreur | 1 |
| App\Entity\Invoice | 1 |
| App\Entity\Shipment | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Params | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Uid | No errors. |
| App\Entity\Livreur | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Shipment | No errors. |
| App\Entity\Detail | No errors. |