Query Metrics
26
Database Queries
3
Different statements
3.66 ms
Query time
1
Invalid entities
88
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.27 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
3296
]
|
||||||||||||||||||||||||||||
| 2 | 0.16 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
14366
]
|
||||||||||||||||||||||||||||
| 3 | 0.13 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
6563
]
|
||||||||||||||||||||||||||||
| 4 | 0.13 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
6166
]
|
||||||||||||||||||||||||||||
| 5 | 0.13 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
7342
]
|
||||||||||||||||||||||||||||
| 6 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
24596
]
|
||||||||||||||||||||||||||||
| 7 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
3984
]
|
||||||||||||||||||||||||||||
| 8 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
7271
]
|
||||||||||||||||||||||||||||
| 9 | 0.14 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
9506
]
|
||||||||||||||||||||||||||||
| 10 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
790
]
|
||||||||||||||||||||||||||||
| 11 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
3958
]
|
||||||||||||||||||||||||||||
| 12 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
5293
]
|
||||||||||||||||||||||||||||
| 13 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
7682
]
|
||||||||||||||||||||||||||||
| 14 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
4271
]
|
||||||||||||||||||||||||||||
| 15 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
8656
]
|
||||||||||||||||||||||||||||
| 16 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
22005
]
|
||||||||||||||||||||||||||||
| 17 | 0.11 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
430
]
|
||||||||||||||||||||||||||||
| 18 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
17366
]
|
||||||||||||||||||||||||||||
| 19 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
11611
]
|
||||||||||||||||||||||||||||
| 20 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
23909
]
|
||||||||||||||||||||||||||||
| 21 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
9687
]
|
||||||||||||||||||||||||||||
| 22 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id = ?
Parameters:
[
774
]
|
||||||||||||||||||||||||||||
| 23 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.active AS active_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.parent_id IS NULL
Parameters:
[] |
||||||||||||||||||||||||||||
| 24 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.active AS active_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.parent_id IS NULL
Parameters:
[] |
||||||||||||||||||||||||||||
| 25 | 0.33 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 236 464 9529 2736 987 25 11660 460 1968 12 669 57 24 11670 55 196 18 9503 43 8763 448 11634 12972 684 34 259 23 205 22366 ] |
||||||||||||||||||||||||||||
| 26 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.active AS active_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.parent_id IS NULL
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\Product | 51 |
| App\Entity\Brand | 30 |
| App\Entity\Category | 7 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Product |
|
| App\Entity\Brand | No errors. |
| App\Entity\Category | No errors. |