Query Metrics
3
Database Queries
3
Different statements
4.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.59 ms |
SELECT t0.id AS id_1, t0.ref1 AS ref1_2, t0.ref2 AS ref2_3, t0.ref3 AS ref3_4, t0.ref4 AS ref4_5 FROM sevs_highlighted_products t0 WHERE t0.id = ?
Parameters: [0 => 2]
|
| 2 | 2.09 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.types AS types_3, t0.ref AS ref_4, t0.description AS description_5, t0.state AS state_6, t0.price AS price_7, t0.rank AS rank_8, t0.disabled AS disabled_9, t0.sub_category_id AS sub_category_id_10, t0.picture AS picture_11 FROM sevs_product t0 WHERE t0.ref IN (?)
Parameters: [
0 => [
0 => 10A,
1 => 4/01117,
2 => 4/01101,
3 => 4/01110
]
]
|
| 3 | 0.92 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_file_name AS original_file_name_3, t0.hash AS hash_4, t0.type FROM sidus_resource t0 WHERE t0.id IN (?) AND t0.type IN ('resource', 'productpicture', 'subcategorypicture', 'restorationpicture', 'linkpicture')
Parameters: [
0 => [
0 => 686,
1 => 687,
2 => 693,
3 => 697
]
]
|
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 |
|---|---|
| SeventiesScooter\BackOfficeBundle\Entity\User\Administrator | No errors. |
| SeventiesScooter\BackOfficeBundle\Entity\Shop\HighlightedProducts | No errors. |
| SeventiesScooter\BackOfficeBundle\Entity\Shop\Product | No errors. |
| SeventiesScooter\BackOfficeBundle\Entity\Shop\SubCategory | No errors. |
| Sidus\FileUploadBundle\Entity\Resource | No errors. |
| SeventiesScooter\BackOfficeBundle\Entity\Shop\ProductPicture | No errors. |
| SeventiesScooter\BackOfficeBundle\Entity\Shop\SubCategoryPicture | No errors. |
| SeventiesScooter\BackOfficeBundle\Entity\RestorationPicture | No errors. |
| SeventiesScooter\BackOfficeBundle\Entity\LinkPicture | No errors. |