Symfony Profiler

Query Metrics

85 Database Queries

19 Different statements

719.26 ms Query time

0 Invalid entities

Queries


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
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
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
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
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 = ?
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
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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
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 = ?
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
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
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 = ?
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
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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
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 >= ?)))

#▲	Time	Info
1	2.34 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"`] View formatted query View runnable query Explain query 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 SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_kind t0 WHERE t0.url = 'osobni-vozidla' LIMIT 1;
2	10.56 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: [`"bmw"`] View formatted query View runnable query Explain query 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 SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.url = 'bmw' LIMIT 1;
3	2.65 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: [`32 1`] View formatted query View runnable query Explain query 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 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 = 32 AND v1_.kind_id = 1 ORDER BY v0_.name ASC;
4	10.52 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: [`"rada-5"`] View formatted query View runnable query Explain query 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 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 = 'rada-5' LIMIT 1;
5	4.86 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 32 202`] View formatted query View runnable query Explain query 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 = ? 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 = 1 AND v0_.manufacturer_id = 32 AND v0_.model_id = 202;
6	2.61 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 Parameters: [`1 32 202`] View formatted query View runnable query Explain query 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 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 = 1 AND v0_.manufacturer_id = 32 AND v0_.model_id = 202 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;
7	9.29 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 32 202 7328 11135 30005 53383 55882 20998 44011 3432 38609 44582 31106 52662 16981 45179 3612 48065 47289 2476 326 43408`] View formatted query View runnable query Explain query 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 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 = 1 AND v0_.manufacturer_id = 32 AND v0_.model_id = 202 AND v0_.id IN (7328, 11135, 30005, 53383, 55882, 20998, 44011, 3432, 38609, 44582, 31106, 52662, 16981, 45179, 3612, 48065, 47289, 2476, 326, 43408) 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;
8	15.03 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: [`7328`] View formatted query View runnable query Explain query 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 = ? 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 = 7328;
9	17.96 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: [`11135`] View formatted query View runnable query Explain query 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 = ? 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 = 11135;
10	3.45 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: [`30005`] View formatted query View runnable query Explain query 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 = ? 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 = 30005;
11	3.69 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: [`53383`] View formatted query View runnable query Explain query 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 = ? 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 = 53383;
12	0.40 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: [`55882`] View formatted query View runnable query Explain query 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 = ? 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 = 55882;
13	0.63 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: [`20998`] View formatted query View runnable query Explain query 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 = ? 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 = 20998;
14	3.08 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: [`44011`] View formatted query View runnable query Explain query 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 = ? 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 = 44011;
15	2.42 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: [`3432`] View formatted query View runnable query Explain query 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 = ? 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 = 3432;
16	5.18 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: [`38609`] View formatted query View runnable query Explain query 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 = ? 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 = 38609;
17	3.95 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: [`44582`] View formatted query View runnable query Explain query 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 = ? 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 = 44582;
18	1.98 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: [`31106`] View formatted query View runnable query Explain query 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 = ? 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 = 31106;
19	0.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: [`52662`] View formatted query View runnable query Explain query 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 = ? 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 = 52662;
20	4.68 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: [`16981`] View formatted query View runnable query Explain query 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 = ? 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 = 16981;
21	2.43 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: [`45179`] View formatted query View runnable query Explain query 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 = ? 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 = 45179;
22	5.06 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: [`3612`] View formatted query View runnable query Explain query 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 = ? 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 = 3612;
23	3.92 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: [`48065`] View formatted query View runnable query Explain query 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 = ? 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 = 48065;
24	0.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: [`47289`] View formatted query View runnable query Explain query 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 = ? 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 = 47289;
25	1.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: [`2476`] View formatted query View runnable query Explain query 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 = ? 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 = 2476;
26	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: [`326`] View formatted query View runnable query Explain query 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 = ? 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 = 326;
27	7.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: [`43408`] View formatted query View runnable query Explain query 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 = ? 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 = 43408;
28	4.79 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: [`432 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 432 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
29	7.72 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 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 412 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
30	5.97 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: [`171 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 171 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
31	5.14 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: [`178 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 178 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
32	0.45 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: [`451 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 451 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
33	0.27 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 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 301 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
34	0.26 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 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 313 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
35	0.26 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: [`291 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 291 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
36	0.24 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: [`444 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 444 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
37	0.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: [`329 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 329 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
38	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: [`422 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 422 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
39	4.58 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: [`376 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 376 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
40	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: [`210 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 210 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
41	5.62 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: [`172 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 172 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
42	5.13 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: [`302 "2026-09-17 13:57:58" "2026-09-17 13:57:58"`] View formatted query View runnable query Explain query 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 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 = 302 AND a0_.valid_from <= '2026-09-17 13:57:58' AND a0_.valid_to >= '2026-09-17 13:57:58' ORDER BY a0_.valid_from DESC LIMIT 1;
43	143.43 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: [] View formatted query View runnable query Explain query 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 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;
44	4.14 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`] View formatted query View runnable query Explain query 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 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 = 1 ORDER BY v0_.name ASC;
45	4.69 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 32 202`] View formatted query View runnable query Explain query 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 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 = 1 AND v1_.manufacturer_id = 32 AND v1_.model_id = 202 ORDER BY v0_.name ASC;
46	59.79 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: [] View formatted query View runnable query Explain query 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 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;
47	0.24 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: [] View formatted query View runnable query Explain query 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 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;
48	16.24 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: [] View formatted query View runnable query Explain query 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 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;
49	3.39 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: [] View formatted query View runnable query Explain query 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 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;
50	30.69 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: [`7328`] View formatted query View runnable query Explain query 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 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 = 7328 ORDER BY t0.main DESC, t0.id ASC;
51	14.93 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: [`432`] View formatted query View runnable query Explain query 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 = ? 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 = 432;
52	3.88 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: [`11135`] View formatted query View runnable query Explain query 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 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 = 11135 ORDER BY t0.main DESC, t0.id ASC;
53	6.08 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`] View formatted query View runnable query Explain query 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 = ? 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 = 412;
54	7.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: [`30005`] View formatted query View runnable query Explain query 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 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 = 30005 ORDER BY t0.main DESC, t0.id ASC;
55	7.40 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: [`171`] View formatted query View runnable query Explain query 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 = ? 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 = 171;
56	3.44 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: [`53383`] View formatted query View runnable query Explain query 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 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 = 53383 ORDER BY t0.main DESC, t0.id ASC;
57	7.36 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: [`178`] View formatted query View runnable query Explain query 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 = ? 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 = 178;
58	3.57 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: [`55882`] View formatted query View runnable query Explain query 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 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 = 55882 ORDER BY t0.main DESC, t0.id ASC;
59	7.41 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: [`451`] View formatted query View runnable query Explain query 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 = ? 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 = 451;
60	3.62 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: [`20998`] View formatted query View runnable query Explain query 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 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 = 20998 ORDER BY t0.main DESC, t0.id ASC;
61	9.73 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: [`44011`] View formatted query View runnable query Explain query 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 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 = 44011 ORDER BY t0.main DESC, t0.id ASC;
62	9.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: [`301`] View formatted query View runnable query Explain query 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 = ? 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 = 301;
63	21.43 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: [`3432`] View formatted query View runnable query Explain query 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 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 = 3432 ORDER BY t0.main DESC, t0.id ASC;
64	7.33 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: [`38609`] View formatted query View runnable query Explain query 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 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 = 38609 ORDER BY t0.main DESC, t0.id ASC;
65	3.10 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`] View formatted query View runnable query Explain query 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 = ? 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 = 313;
66	5.88 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: [`44582`] View formatted query View runnable query Explain query 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 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 = 44582 ORDER BY t0.main DESC, t0.id ASC;
67	13.04 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: [`31106`] View formatted query View runnable query Explain query 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 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 = 31106 ORDER BY t0.main DESC, t0.id ASC;
68	3.25 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: [`291`] View formatted query View runnable query Explain query 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 = ? 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 = 291;
69	29.80 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: [`52662`] View formatted query View runnable query Explain query 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 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 = 52662 ORDER BY t0.main DESC, t0.id ASC;
70	2.92 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: [`444`] View formatted query View runnable query Explain query 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 = ? 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 = 444;
71	0.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: [`16981`] View formatted query View runnable query Explain query 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 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 = 16981 ORDER BY t0.main DESC, t0.id ASC;
72	9.82 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: [`329`] View formatted query View runnable query Explain query 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 = ? 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 = 329;
73	3.83 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: [`45179`] View formatted query View runnable query Explain query 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 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 = 45179 ORDER BY t0.main DESC, t0.id ASC;
74	3.05 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: [`422`] View formatted query View runnable query Explain query 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 = ? 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 = 422;
75	3.67 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: [`3612`] View formatted query View runnable query Explain query 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 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 = 3612 ORDER BY t0.main DESC, t0.id ASC;
76	19.07 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: [`376`] View formatted query View runnable query Explain query 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 = ? 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 = 376;
77	0.82 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: [`48065`] View formatted query View runnable query Explain query 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 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 = 48065 ORDER BY t0.main DESC, t0.id ASC;
78	8.16 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: [`210`] View formatted query View runnable query Explain query 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 = ? 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 = 210;
79	3.32 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: [`47289`] View formatted query View runnable query Explain query 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 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 = 47289 ORDER BY t0.main DESC, t0.id ASC;
80	5.28 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: [`172`] View formatted query View runnable query Explain query 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 = ? 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 = 172;
81	21.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: [`2476`] View formatted query View runnable query Explain query 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 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 = 2476 ORDER BY t0.main DESC, t0.id ASC;
82	7.56 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: [`302`] View formatted query View runnable query Explain query 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 = ? 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 = 302;
83	9.54 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: [`326`] View formatted query View runnable query Explain query 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 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 = 326 ORDER BY t0.main DESC, t0.id ASC;
84	4.80 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: [`43408`] View formatted query View runnable query Explain query 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 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 = 43408 ORDER BY t0.main DESC, t0.id ASC;
85	13.02 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 13:58:00" "2026-09-17 13:58:00" "2026-09-17 13:58:00"`] View formatted query View runnable query Explain query 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 >= ? ) ) ) 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 >= '2026-09-17 13:58:00' AND ((a2_.id IS NULL OR (a2_.valid_from <= '2026-09-17 13:58:00' AND a2_.valid_to >= '2026-09-17 13:58:00')));

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.

Symfony Profiler

GET https://test.autanet.cz/_fragment?_path=_format%3Dhtml%26_locale%3D2%26_controller%3DApp%255CController%255CVehicleTipController%253A%253Atip

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping