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 = 'osobni-vozidla' 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 t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.url = 'hyundai' 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 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 = 107 AND v1_.kind_id = 1 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 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 = 'ostatni' 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 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 = 107 AND v0_.model_id = 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 = ?
  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 = 107 AND v0_.model_id = 20 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_.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;

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;

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 = 107 AND v1_.model_id = 20 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_.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 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 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.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
  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 12:59:23' AND ((a2_.id IS NULL OR (a2_.valid_from <= '2026-09-17 12:59:23' AND a2_.valid_to >= '2026-09-17 12:59:23')));

SELECT
  t0.id AS id_1,
  t0.rank AS rank_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.visible AS visible_5,
  t0.main AS main_6,
  t0.title AS title_7,
  t0.description AS description_8,
  t0.text AS text_9
FROM
  page t0
WHERE
  t0.visible = ?
  AND t0.main = ?
ORDER BY
  t0.rank ASC

SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = 1 AND t0.main = 1 ORDER BY t0.rank ASC;

SELECT
  t0.id AS id_1,
  t0.rank AS rank_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.visible AS visible_5,
  t0.main AS main_6,
  t0.title AS title_7,
  t0.description AS description_8,
  t0.text AS text_9
FROM
  page t0
WHERE
  t0.visible = ?
  AND t0.main = ?
ORDER BY
  t0.rank ASC

SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = 1 AND t0.main = 0 ORDER BY t0.rank ASC;