Query Metrics
6
Database Queries
5
Different statements
2.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.26 ms (44.17%) |
1 |
SELECT t0.countries_id AS countries_id_1, t0.countries_name AS countries_name_2, t0.countries_iso_code_2 AS countries_iso_code_2_3, t0.countries_iso_code_3 AS countries_iso_code_3_4, t0.address_format_id AS address_format_id_5, t0.countries_distri_name AS countries_distri_name_6, t0.countries_adresse AS countries_adresse_7, t0.countries_website AS countries_website_8, t0.countries_url AS countries_url_9, t0.countries_tel AS countries_tel_10, t0.countries_logo AS countries_logo_11, t0.countries_blocage AS countries_blocage_12, t0.countries_commercial AS countries_commercial_13, t0.countries_texte_prix01 AS countries_texte_prix01_14, t0.countries_texte_prix02 AS countries_texte_prix02_15, t0.countries_texte_email01 AS countries_texte_email01_16, t0.countries_email AS countries_email_17, t0.countries_soleil AS countries_soleil_18, t0.countries_bienvenue AS countries_bienvenue_19, t0.countries_rank AS countries_rank_20 FROM countries t0 WHERE t0.countries_id = ?
Parameters:
[
73
]
|
|
0.61 ms (21.40%) |
1 |
SELECT c0_.countries_id AS countries_id_0, c0_.countries_name AS countries_name_1, c0_.countries_iso_code_2 AS countries_iso_code_2_2, c0_.countries_iso_code_3 AS countries_iso_code_3_3, c0_.address_format_id AS address_format_id_4, c0_.countries_distri_name AS countries_distri_name_5, c0_.countries_adresse AS countries_adresse_6, c0_.countries_website AS countries_website_7, c0_.countries_url AS countries_url_8, c0_.countries_tel AS countries_tel_9, c0_.countries_logo AS countries_logo_10, c0_.countries_blocage AS countries_blocage_11, c0_.countries_commercial AS countries_commercial_12, c0_.countries_texte_prix01 AS countries_texte_prix01_13, c0_.countries_texte_prix02 AS countries_texte_prix02_14, c0_.countries_texte_email01 AS countries_texte_email01_15, c0_.countries_email AS countries_email_16, c0_.countries_soleil AS countries_soleil_17, c0_.countries_bienvenue AS countries_bienvenue_18, c0_.countries_rank AS countries_rank_19 FROM countries c0_
Parameters:
[] |
|
0.48 ms (16.84%) |
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.28 ms (9.74%) |
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:
[
24362
]
|
|
0.22 ms (7.85%) |
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:
[
24362
]
|
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\Country | No errors. |
| App\Entity\PriceGroup | 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. |