Symfony Profiler

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 = 'nakladni-vozidla' 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 = ?

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 = 4;

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 = ?
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 = 4 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_.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 = 4 AND v0_.id IN (48778, 7417, 43334, 45890, 12887, 33059, 18779, 9775, 54222, 10109, 55318, 48400, 43892, 40413, 18644, 10739, 16010, 5319, 9879, 55649) 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 = 48778;

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 = 7417;

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 = 43334;

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 = 45890;

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 = 12887;

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 = 33059;

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 = 18779;

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 = 9775;

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 = 54222;

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 = 10109;

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 = 55318;

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 = 48400;

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 = 43892;

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 = 40413;

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 = 18644;

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 = 10739;

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 = 16010;

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 = 5319;

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 = 9879;

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 = 55649;

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 = 383 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 432 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 422 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 347 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 378 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 179 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 384 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 216 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 202 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 324 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 185 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 445 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 193 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' 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 = 229 AND a0_.valid_from <= '2026-09-17 11:21:24' AND a0_.valid_to >= '2026-09-17 11:21:24' ORDER BY a0_.valid_from DESC LIMIT 1;