Query Metrics
29
Database Queries
9
Different statements
7.66 ms
Query time
0
Invalid entities
38
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.53 ms (46.08%) |
16 |
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
"principalColor"
]
|
|
0.68 ms (8.89%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.content AS content_4, t0.image_bkg AS image_bkg_5, t0.header_image AS header_image_6, t0.subtitle AS subtitle_7 FROM page t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.64 ms (8.34%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"groups"
]
|
|
0.63 ms (8.17%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.gallery AS gallery_4, t0.amount AS amount_5, t0.is_enabled AS is_enabled_6, t0.image AS image_7, t0.max_quantity_in_cart AS max_quantity_in_cart_8, t0.short_description AS short_description_9, t0.is_recommanded AS is_recommanded_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.day_start AS day_start_13, t0.day_end AS day_end_14, t0.subscription_interval AS subscription_interval_15, t0.price_id AS price_id_16, t0.event_start_hour AS event_start_hour_17, t0.event_end_time AS event_end_time_18, t0.start_recurring AS start_recurring_19, t0.end_recurring AS end_recurring_20, t0.start_month AS start_month_21, t0.end_month AS end_month_22, t0.number_day_start AS number_day_start_23, t0.number_day_end AS number_day_end_24, t0.is_deleted AS is_deleted_25, t0.disabled_dates AS disabled_dates_26, t0.is_disabled AS is_disabled_27, t0.product_category_id AS product_category_id_28, t0.type_id AS type_id_29 FROM product t0 WHERE t0.is_recommanded = ? LIMIT 1
Parameters:
[
1
]
|
|
0.60 ms (7.82%) |
4 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4 FROM policy_term t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"cgu"
]
|
|
0.54 ms (7.09%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5 FROM product_category t0
Parameters:
[] |
|
0.50 ms (6.50%) |
1 |
SELECT min(p0_.amount) AS sclr_0 FROM product p0_
Parameters:
[] |
|
0.31 ms (4.03%) |
1 |
SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0 ORDER BY t0.ordre ASC
Parameters:
[] |
|
0.23 ms (3.07%) |
1 |
SELECT max(p0_.amount) AS sclr_0 FROM product p0_
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\ProductCategory | 14 |
| App\Entity\Parameter | 11 |
| App\Entity\Menu | 4 |
| App\Entity\PolicyTerm | 4 |
| App\Entity\Page | 3 |
| App\Entity\Product | 1 |
| App\Entity\ProductType | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ProductCategory | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Parameter | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\ProductType | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\PolicyTerm | No errors. |