Query Metrics
26
Database Queries
16
Different statements
280.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.36 ms |
SELECT t0.id AS id_1, t0.id_import AS id_import_2, t0.visible AS visible_3, t0.create_at AS create_at_4, t0.hidden_at AS hidden_at_5, t0.first_seen_at AS first_seen_at_6, t0.last_seen_at AS last_seen_at_7, t0.seo_slug AS seo_slug_8, t0.seo_title AS seo_title_9, t0.seo_description AS seo_description_10, t0.seo_h1 AS seo_h1_11, t0.url_generated_at AS url_generated_at_12, t0.vin AS vin_13, t0.places AS places_14, t0.doors AS doors_15, t0.load_capacity AS load_capacity_16, t0.total_weight AS total_weight_17, t0.state AS state_18, t0.mileage AS mileage_19, t0.mileage_unit AS mileage_unit_20, t0.made_date AS made_date_21, t0.price AS price_22, t0.vat AS vat_23, t0.price_before AS price_before_24, t0.price_leasing AS price_leasing_25, t0.payment_leasing_count AS payment_leasing_count_26, t0.eco_vat AS eco_vat_27, t0.engine_volume AS engine_volume_28, t0.stk_to AS stk_to_29, t0.first_owner AS first_owner_30, t0.service_book AS service_book_31, t0.tuning AS tuning_32, t0.note AS note_33, t0.engine_power AS engine_power_34, t0.type AS type_35, t0.not_crashed AS not_crashed_36, t0.financial_info AS financial_info_37, t0.payment_leasing AS payment_leasing_38, t0.gearbox AS gearbox_39, t0.category_id AS category_id_40, t0.kind_id AS kind_id_41, t0.sub_kind_id AS sub_kind_id_42, t0.model_id AS model_id_43, t0.body_id AS body_id_44, t0.color_id AS color_id_45, t0.fuel_id AS fuel_id_46, t0.condition_vehicle_id AS condition_vehicle_id_47, t0.part_kind_id AS part_kind_id_48, t0.manufacturer_id AS manufacturer_id_49, t50.id AS id_51, t50.create_at AS create_at_52, t50.end_at AS end_at_53, t50.vehicle_id AS vehicle_id_54, t50.autanet_partner_id AS autanet_partner_id_55, t0.dealer_id AS dealer_id_56 FROM vehicle t0 LEFT JOIN vehicle_tip t50 ON t50.vehicle_id = t0.id WHERE t0.id = ?
Parameters:
[
24425
]
|
| 2 | 45.17 ms |
SELECT t0.id AS id_1, t0.day AS day_2, t0.summer AS summer_3, t0.description AS description_4, t0.dealer_id AS dealer_id_5 FROM dealer_open_hour t0 WHERE t0.dealer_id = ? AND t0.summer = ?
Parameters:
[ 307 "1" ] |
| 3 | 4.20 ms |
SELECT v0_.id AS id_0, v0_.id_import AS id_import_1, v0_.visible AS visible_2, v0_.create_at AS create_at_3, v0_.hidden_at AS hidden_at_4, v0_.first_seen_at AS first_seen_at_5, v0_.last_seen_at AS last_seen_at_6, v0_.seo_slug AS seo_slug_7, v0_.seo_title AS seo_title_8, v0_.seo_description AS seo_description_9, v0_.seo_h1 AS seo_h1_10, v0_.url_generated_at AS url_generated_at_11, v0_.vin AS vin_12, v0_.places AS places_13, v0_.doors AS doors_14, v0_.load_capacity AS load_capacity_15, v0_.total_weight AS total_weight_16, v0_.state AS state_17, v0_.mileage AS mileage_18, v0_.mileage_unit AS mileage_unit_19, v0_.made_date AS made_date_20, v0_.price AS price_21, v0_.vat AS vat_22, v0_.price_before AS price_before_23, v0_.price_leasing AS price_leasing_24, v0_.payment_leasing_count AS payment_leasing_count_25, v0_.eco_vat AS eco_vat_26, v0_.engine_volume AS engine_volume_27, v0_.stk_to AS stk_to_28, v0_.first_owner AS first_owner_29, v0_.service_book AS service_book_30, v0_.tuning AS tuning_31, v0_.note AS note_32, v0_.engine_power AS engine_power_33, v0_.type AS type_34, v0_.not_crashed AS not_crashed_35, v0_.financial_info AS financial_info_36, v0_.payment_leasing AS payment_leasing_37, v0_.gearbox AS gearbox_38, v0_.category_id AS category_id_39, v0_.kind_id AS kind_id_40, v0_.sub_kind_id AS sub_kind_id_41, v0_.model_id AS model_id_42, v0_.body_id AS body_id_43, v0_.color_id AS color_id_44, v0_.fuel_id AS fuel_id_45, v0_.condition_vehicle_id AS condition_vehicle_id_46, v0_.part_kind_id AS part_kind_id_47, v0_.manufacturer_id AS manufacturer_id_48, v0_.dealer_id AS dealer_id_49 FROM vehicle v0_ WHERE v0_.visible <> 0 AND v0_.id <> ? AND v0_.body_id = ? AND v0_.dealer_id = ? ORDER BY v0_.create_at DESC LIMIT 4
Parameters:
[ 24425 10 307 ] |
| 4 | 2.41 ms |
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
51737
]
|
| 5 | 8.30 ms |
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
36165
]
|
| 6 | 3.62 ms |
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
7239
]
|
| 7 | 0.57 ms |
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4, t0.autanet_partner_id AS autanet_partner_id_5 FROM vehicle_tip t0 WHERE t0.vehicle_id = ?
Parameters:
[
46172
]
|
| 8 | 3.60 ms |
SELECT a0_.id AS id_0, a0_.valid_from AS valid_from_1, a0_.valid_to AS valid_to_2, a0_.created_at AS created_at_3, a0_.dealer_id AS dealer_id_4 FROM autanet_partner a0_ WHERE a0_.dealer_id = ? AND a0_.valid_from <= ? AND a0_.valid_to >= ? ORDER BY a0_.valid_from DESC LIMIT 1
Parameters:
[ 307 "2026-09-17 13:58:45" "2026-09-17 13:58:45" ] |
| 9 | 4.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
24425
]
|
| 10 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_fuel t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 11 | 53.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_body t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 12 | 3.30 ms |
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.id = ?
Parameters:
[
307
]
|
| 13 | 6.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_color t0 WHERE t0.id = ?
Parameters:
[
37
]
|
| 14 | 3.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_equipment t0 INNER JOIN vehicle_vehicle_equipment ON t0.id = vehicle_vehicle_equipment.vehicle_equipment_id WHERE vehicle_vehicle_equipment.vehicle_id = ?
Parameters:
[
24425
]
|
| 15 | 3.55 ms |
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:
[
66
]
|
| 16 | 14.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
51737
]
|
| 17 | 10.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = ?
Parameters:
[
233
]
|
| 18 | 29.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = ?
Parameters:
[
447
]
|
| 19 | 3.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
36165
]
|
| 20 | 6.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
7239
]
|
| 21 | 14.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = ?
Parameters:
[
1429
]
|
| 22 | 15.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
46172
]
|
| 23 | 21.69 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = ?
Parameters:
[
1437
]
|
| 24 | 1.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.dealer_id AS dealer_id_3 FROM dealer_phone t0 WHERE t0.dealer_id = ?
Parameters:
[
307
]
|
| 25 | 16.56 ms |
SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = ? AND t0.main = ? ORDER BY t0.rank ASC
Parameters:
[ 1 1 ] |
| 26 | 0.63 ms |
SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = ? AND t0.main = ? ORDER BY t0.rank ASC
Parameters:
[ 1 0 ] |
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\Vehicle | 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\VehiclePartKind | No errors. |
| App\Entity\VehicleManufacturer | No errors. |
| App\Entity\VehicleTip | No errors. |
| App\Entity\AutanetPartner | No errors. |
| App\Entity\Dealer | No errors. |
| App\Entity\VehicleFinancial | No errors. |
| App\Entity\VehicleEquipment | No errors. |
| App\Entity\VehicleImage | No errors. |
| App\Entity\VehicleForm | No errors. |
| App\Entity\DealerOpenHour | No errors. |
| App\Entity\District | No errors. |
| App\Entity\DealerImage | No errors. |
| App\Entity\DealerPhone | No errors. |
| App\Entity\DealerImport | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\BlogKind | No errors. |
| App\Entity\BlogImage | No errors. |