Query Metrics
83
Database Queries
19
Different statements
808.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_kind t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"osobni-vozidla"
]
|
| 2 | 5.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"skoda"
]
|
| 3 | 62.56 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2, v0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_3 FROM vehicle_model v0_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.model_id LEFT JOIN dealer d2_ ON v1_.dealer_id = d2_.id WHERE v1_.visible = 1 AND d2_.visible = 1 AND v1_.manufacturer_id = ? AND v1_.kind_id = ? ORDER BY v0_.name ASC
Parameters:
[ 247 1 ] |
| 4 | 30.90 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.url = ? LIMIT 1
Parameters:
[
"octavia"
]
|
| 5 | 9.64 ms |
SELECT count(DISTINCT v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN dealer d1_ ON v0_.dealer_id = d1_.id LEFT JOIN vehicle_manufacturer v2_ ON v0_.manufacturer_id = v2_.id WHERE v0_.visible <> 0 AND d1_.visible = 1 AND v0_.kind_id = ? AND v0_.manufacturer_id = ? AND v0_.model_id = ?
Parameters:
[ 1 247 1508 ] |
| 6 | 316.07 ms |
SELECT DISTINCT v0_.id AS id_0, v0_.price AS price_1 FROM vehicle v0_ LEFT JOIN dealer d1_ ON v0_.dealer_id = d1_.id LEFT JOIN vehicle_manufacturer v2_ ON v0_.manufacturer_id = v2_.id WHERE v0_.visible <> 0 AND d1_.visible = 1 AND v0_.kind_id = ? AND v0_.manufacturer_id = ? AND v0_.model_id = ? ORDER BY CASE WHEN d1_.basic_advertising = 1 THEN 1 ELSE 0 END ASC, CASE WHEN v0_.price IS NULL OR v0_.price = 0 THEN 1 ELSE 0 END ASC, v0_.price ASC LIMIT 20 OFFSET 20
Parameters:
[ 1 247 1508 ] |
| 7 | 24.72 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_ LEFT JOIN dealer d1_ ON v0_.dealer_id = d1_.id LEFT JOIN vehicle_manufacturer v2_ ON v0_.manufacturer_id = v2_.id WHERE v0_.visible <> 0 AND d1_.visible = 1 AND v0_.kind_id = ? AND v0_.manufacturer_id = ? AND v0_.model_id = ? AND v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY CASE WHEN d1_.basic_advertising = 1 THEN 1 ELSE 0 END ASC, CASE WHEN v0_.price IS NULL OR v0_.price = 0 THEN 1 ELSE 0 END ASC, v0_.price ASC
Parameters:
[ 1 247 1508 11255 52527 39396 51146 48771 12089 38761 38968 47530 53935 39756 44348 23899 5167 8347 56462 54494 21103 44479 21078 ] |
| 8 | 9.54 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:
[
11255
]
|
| 9 | 5.75 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:
[
52527
]
|
| 10 | 9.74 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:
[
39396
]
|
| 11 | 4.35 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:
[
51146
]
|
| 12 | 5.22 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:
[
12089
]
|
| 13 | 0.53 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:
[
48771
]
|
| 14 | 0.29 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:
[
38761
]
|
| 15 | 0.21 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:
[
38968
]
|
| 16 | 3.58 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:
[
47530
]
|
| 17 | 4.78 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:
[
53935
]
|
| 18 | 3.78 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:
[
39756
]
|
| 19 | 5.02 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:
[
44348
]
|
| 20 | 2.49 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:
[
23899
]
|
| 21 | 2.60 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:
[
5167
]
|
| 22 | 0.24 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:
[
8347
]
|
| 23 | 0.51 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:
[
54494
]
|
| 24 | 3.28 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:
[
56462
]
|
| 25 | 0.29 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:
[
21103
]
|
| 26 | 3.89 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:
[
44479
]
|
| 27 | 0.65 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:
[
21078
]
|
| 28 | 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:
[ 412 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 29 | 2.37 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:
[ 407 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 30 | 3.77 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:
[ 229 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 31 | 2.99 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:
[ 452 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 32 | 4.55 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:
[ 354 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 33 | 0.41 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:
[ 343 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 34 | 4.43 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:
[ 301 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 35 | 2.43 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:
[ 230 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 36 | 2.35 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:
[ 280 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 37 | 0.38 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:
[ 227 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 38 | 4.63 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:
[ 313 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 39 | 3.80 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:
[ 360 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 40 | 0.33 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:
[ 275 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 41 | 3.29 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:
[ 328 "2026-09-17 12:08:44" "2026-09-17 12:08:44" ] |
| 42 | 91.36 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_category v0_ INNER JOIN vehicle v1_ ON v0_.id = v1_.category_id ORDER BY v0_.name ASC
Parameters:
[] |
| 43 | 15.45 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_manufacturer v0_ INNER JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id LEFT JOIN dealer d2_ ON v1_.dealer_id = d2_.id WHERE v1_.visible = 1 AND d2_.visible = 1 AND v1_.kind_id = ? ORDER BY v0_.name ASC
Parameters:
[
1
]
|
| 44 | 2.59 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_body v0_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.body_id WHERE v1_.visible = 1 AND v1_.kind_id = ? AND v1_.manufacturer_id = ? AND v1_.model_id = ? ORDER BY v0_.name ASC
Parameters:
[ 1 247 1508 ] |
| 45 | 11.32 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1 FROM vehicle_fuel v0_ INNER JOIN vehicle v1_ ON v0_.id = v1_.fuel_id WHERE v1_.visible = 1 ORDER BY v0_.name ASC
Parameters:
[] |
| 46 | 8.59 ms |
SELECT v0_.gearbox AS gearbox_0 FROM vehicle v0_ WHERE v0_.visible <> 0 AND v0_.gearbox IS NOT NULL GROUP BY v0_.gearbox ORDER BY v0_.gearbox ASC
Parameters:
[] |
| 47 | 6.85 ms |
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:
[] |
| 48 | 4.91 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 ORDER BY t0.name ASC
Parameters:
[] |
| 49 | 7.18 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:
[
11255
]
|
| 50 | 0.42 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:
[
412
]
|
| 51 | 0.59 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:
[
52527
]
|
| 52 | 5.58 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:
[
407
]
|
| 53 | 1.29 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:
[
39396
]
|
| 54 | 3.80 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:
[
229
]
|
| 55 | 2.11 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:
[
51146
]
|
| 56 | 6.89 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:
[
452
]
|
| 57 | 2.30 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:
[
12089
]
|
| 58 | 0.22 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:
[
354
]
|
| 59 | 0.45 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:
[
48771
]
|
| 60 | 0.17 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:
[
343
]
|
| 61 | 5.42 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:
[
38761
]
|
| 62 | 3.39 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:
[
301
]
|
| 63 | 1.25 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:
[
38968
]
|
| 64 | 0.22 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:
[
230
]
|
| 65 | 0.46 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:
[
47530
]
|
| 66 | 1.22 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:
[
280
]
|
| 67 | 1.18 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:
[
53935
]
|
| 68 | 4.28 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:
[
39756
]
|
| 69 | 6.46 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:
[
227
]
|
| 70 | 3.58 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:
[
44348
]
|
| 71 | 2.72 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:
[
23899
]
|
| 72 | 3.42 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:
[
313
]
|
| 73 | 0.74 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:
[
5167
]
|
| 74 | 1.67 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:
[
360
]
|
| 75 | 8.13 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:
[
8347
]
|
| 76 | 1.01 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:
[
275
]
|
| 77 | 0.60 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:
[
54494
]
|
| 78 | 7.41 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:
[
56462
]
|
| 79 | 8.72 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:
[
21103
]
|
| 80 | 2.35 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:
[
328
]
|
| 81 | 2.95 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:
[
44479
]
|
| 82 | 2.85 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:
[
21078
]
|
| 83 | 8.34 ms |
SELECT v0_.id AS id_0, v0_.create_at AS create_at_1, v0_.end_at AS end_at_2, v0_.vehicle_id AS vehicle_id_3, v0_.autanet_partner_id AS autanet_partner_id_4 FROM vehicle_tip v0_ INNER JOIN vehicle v1_ ON v0_.vehicle_id = v1_.id LEFT JOIN autanet_partner a2_ ON v0_.autanet_partner_id = a2_.id WHERE v1_.visible = 1 AND v0_.end_at >= ? AND ((a2_.id IS NULL OR (a2_.valid_from <= ? AND a2_.valid_to >= ?)))
Parameters:
[ "2026-09-17 12:08:46" "2026-09-17 12:08:46" "2026-09-17 12:08:46" ] |
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\VehicleKind | No errors. |
| App\Entity\Vehicle | No errors. |
| App\Entity\VehicleManufacturer | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\VehicleModel | No errors. |
| App\Entity\Dealer | No errors. |
| App\Entity\VehicleCategory | No errors. |
| App\Entity\VehicleSubKind | 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\VehicleFinancial | No errors. |
| App\Entity\VehicleEquipment | No errors. |
| App\Entity\VehicleImage | No errors. |
| App\Entity\VehicleTip | No errors. |
| App\Entity\AutanetPartner | No errors. |
| App\Entity\VehicleForm | No errors. |
| App\Entity\Region | 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. |