Query Metrics
7
Database Queries
7
Different statements
1.49 ms
Query time
0
Invalid entities
57
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.52 ms (34.72%) |
1 |
SELECT t0.id AS id_1, t0.user AS user_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.pricefree AS pricefree_6, t0.pricedriver AS pricedriver_7, t0.price AS price_8, t0.year AS year_9, t0.miles AS miles_10, t0.brand AS brand_11, t0.horsepower AS horsepower_12, t0.model AS model_13, t0.brandkey AS brandkey_14, t0.modelkey AS modelkey_15, t0.gearbox AS gearbox_16, t0.body AS body_17, t0.seats AS seats_18, t0.engine AS engine_19, t0.color_int AS color_int_20, t0.color_ext AS color_ext_21, t0.transmission AS transmission_22, t0.saddlery AS saddlery_23, t0.typology AS typology_24, t0.thumbnail0 AS thumbnail0_25, t0.thumbnail1 AS thumbnail1_26, t0.thumbnail2 AS thumbnail2_27, t0.thumbnail3 AS thumbnail3_28, t0.thumbnail4 AS thumbnail4_29, t0.thumbnail5 AS thumbnail5_30, t0.thumbnail6 AS thumbnail6_31, t0.thumbnail7 AS thumbnail7_32, t0.thumbnail8 AS thumbnail8_33, t0.thumbnail9 AS thumbnail9_34, t0.delivery AS delivery_35, t0.driver AS driver_36, t0.extrakm AS extrakm_37, t0.audiovisual AS audiovisual_38, t0.event AS event_39, t0.wedding AS wedding_40, t0.hobby AS hobby_41, t0.location AS location_42, t0.locationfull AS locationfull_43, t0.online AS online_44, t0.views AS views_45, t0.stars AS stars_46, t0.reviews AS reviews_47, t0.created_at AS created_at_48, t0.idprop AS idprop_49, t0.immat AS immat_50 FROM vehicules t0 WHERE t0.id = ?
Parameters:
[
"CRV-CR181019103234"
]
|
|
0.24 ms (15.89%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM bodies t0
Parameters:
[] |
|
0.20 ms (13.38%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM saddleries t0
Parameters:
[] |
|
0.15 ms (10.09%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.info_color AS info_color_3 FROM colors_int t0
Parameters:
[] |
|
0.14 ms (9.29%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.info_color AS info_color_3 FROM colors_ext t0
Parameters:
[] |
|
0.14 ms (9.29%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM gears t0
Parameters:
[] |
|
0.11 ms (7.33%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM transmissions t0
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\Bodies | 19 |
| App\Entity\ColorsInt | 12 |
| App\Entity\ColorsExt | 12 |
| App\Entity\Saddleries | 7 |
| App\Entity\Gears | 3 |
| App\Entity\Transmissions | 3 |
| App\Entity\Vehicules | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Vehicules | No errors. |
| App\Entity\Bodies | No errors. |
| App\Entity\ColorsInt | No errors. |
| App\Entity\ColorsExt | No errors. |
| App\Entity\Saddleries | No errors. |
| App\Entity\Gears | No errors. |
| App\Entity\Transmissions | No errors. |