Query Metrics
271
Database Queries
8
Different statements
224.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
146.00 ms (65.12%) |
192 |
SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = ? AND t0.visible = ?
Parameters:
[ 419 "1" ] |
|
37.62 ms (16.78%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.dealer_id AS dealer_id_4 FROM dealer_image t0 WHERE t0.dealer_id = ? ORDER BY t0.main DESC
Parameters:
[
278
]
|
|
22.38 ms (9.98%) |
52 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4, t0.region_id AS region_id_5 FROM district t0 WHERE t0.id = ?
Parameters:
[
11
]
|
|
10.29 ms (4.59%) |
14 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
6.59 ms (2.94%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.auth_seller AS auth_seller_3, t0.city AS city_4, t0.street AS street_5, t0.check_vin AS check_vin_6, t0.visible AS visible_7, t0.basic_advertising AS basic_advertising_8, t0.email AS email_9, t0.www AS www_10, t0.description AS description_11, t0.lng AS lng_12, t0.lat AS lat_13, t0.rank AS rank_14, t0.logo AS logo_15, t0.import_id AS import_id_16, t0.name_import_vehicle AS name_import_vehicle_17, t0.id_import_vehicle AS id_import_vehicle_18, t0.id_export_cars AS id_export_cars_19, t0.url AS url_20, t0.opening_hours_note AS opening_hours_note_21, t0.district_id AS district_id_22 FROM dealer t0 WHERE t0.visible = ? ORDER BY t0.name ASC
Parameters:
[
"1"
]
|
|
1.02 ms (0.46%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.auth_seller AS auth_seller_2, d0_.city AS city_3, d0_.street AS street_4, d0_.check_vin AS check_vin_5, d0_.visible AS visible_6, d0_.basic_advertising AS basic_advertising_7, d0_.email AS email_8, d0_.www AS www_9, d0_.description AS description_10, d0_.lng AS lng_11, d0_.lat AS lat_12, d0_.rank AS rank_13, d0_.logo AS logo_14, d0_.import_id AS import_id_15, d0_.name_import_vehicle AS name_import_vehicle_16, d0_.id_import_vehicle AS id_import_vehicle_17, d0_.id_export_cars AS id_export_cars_18, d0_.url AS url_19, d0_.opening_hours_note AS opening_hours_note_20, d0_.district_id AS district_id_21 FROM dealer d0_ WHERE d0_.visible = ? AND ((d0_.basic_advertising IS NULL OR d0_.basic_advertising = 0)) ORDER BY d0_.name ASC
Parameters:
[
"1"
]
|
|
0.15 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4, t0.region_id AS region_id_5 FROM district t0 ORDER BY t0.name ASC
Parameters:
[] |
|
0.13 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4 FROM region t0 ORDER BY t0.name ASC
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Dealer | No errors. |
| App\Entity\District | No errors. |
| App\Entity\DealerImage | No errors. |
| App\Entity\DealerPhone | No errors. |
| App\Entity\DealerOpenHour | No errors. |
| App\Entity\DealerImport | No errors. |
| App\Entity\Vehicle | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\VehicleCategory | No errors. |
| App\Entity\VehicleKind | No errors. |
| App\Entity\VehicleSubKind | No errors. |
| App\Entity\VehicleModel | No errors. |
| App\Entity\VehicleBody | No errors. |
| App\Entity\VehicleColor | No errors. |
| App\Entity\VehicleFuel | No errors. |
| App\Entity\VehicleCondition | No errors. |
| App\Entity\VehicleFinancial | No errors. |
| App\Entity\VehicleEquipment | No errors. |
| App\Entity\VehicleImage | No errors. |
| App\Entity\VehiclePartKind | No errors. |
| App\Entity\VehicleManufacturer | No errors. |
| App\Entity\VehicleTip | No errors. |
| App\Entity\VehicleForm | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\BlogKind | No errors. |
| App\Entity\BlogImage | No errors. |