Symfony Profiler

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_
  INNER JOIN dealer d1_ ON v0_.dealer_id = d1_.id
WHERE
  v0_.visible = 1
  AND d1_.visible = 1
  AND (
    SELECT
      COUNT(*)
    FROM
      vehicle_image v2_
    WHERE
      v2_.vehicle_id = v0_.id
  ) > 0
ORDER BY
  RAND() ASC
LIMIT
  12

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_ INNER JOIN dealer d1_ ON v0_.dealer_id = d1_.id WHERE v0_.visible = 1 AND d1_.visible = 1 AND (SELECT COUNT(*) FROM vehicle_image v2_ WHERE v2_.vehicle_id = v0_.id) > 0 ORDER BY RAND() ASC LIMIT 12;

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  vehicle v0_
  INNER JOIN vehicle_kind v1_ ON v0_.kind_id = v1_.id
  INNER JOIN dealer d2_ ON v0_.dealer_id = d2_.id
WHERE
  v0_.visible = 1
  AND d2_.visible = 1
  AND v1_.url IN (?, ?, ?, ?, ?)

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ INNER JOIN vehicle_kind v1_ ON v0_.kind_id = v1_.id INNER JOIN dealer d2_ ON v0_.dealer_id = d2_.id WHERE v0_.visible = 1 AND d2_.visible = 1 AND v1_.url IN ('osobni-vozidla', 'uzitkova-vozidla', 'nakladni-vozidla', 'obytna-vozidla', 'motorky-skutry');

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.url AS url_2,
  b0_.description AS description_3,
  b0_.text AS text_4,
  b0_.keyword AS keyword_5,
  b0_.text_source AS text_source_6,
  b0_.visible AS visible_7,
  b0_.visible_homepage AS visible_homepage_8,
  b0_.create_at AS create_at_9,
  b0_.import_id AS import_id_10,
  b0_.top AS top_11,
  b0_.redirect AS redirect_12,
  b0_.main_kind_id AS main_kind_id_13,
  b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14,
  b0_.vehicle_model_id AS vehicle_model_id_15
FROM
  blog b0_
  INNER JOIN blog_blog_kind b2_ ON b0_.id = b2_.blog_id
  INNER JOIN blog_kind b1_ ON b1_.id = b2_.blog_kind_id
WHERE
  b1_.url = ?
  AND b0_.visible = 1
  AND b0_.create_at <= ?
ORDER BY
  b0_.create_at DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.url AS url_2, b0_.description AS description_3, b0_.text AS text_4, b0_.keyword AS keyword_5, b0_.text_source AS text_source_6, b0_.visible AS visible_7, b0_.visible_homepage AS visible_homepage_8, b0_.create_at AS create_at_9, b0_.import_id AS import_id_10, b0_.top AS top_11, b0_.redirect AS redirect_12, b0_.main_kind_id AS main_kind_id_13, b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14, b0_.vehicle_model_id AS vehicle_model_id_15 FROM blog b0_ INNER JOIN blog_blog_kind b2_ ON b0_.id = b2_.blog_id INNER JOIN blog_kind b1_ ON b1_.id = b2_.blog_kind_id WHERE b1_.url = 'testy-aut' AND b0_.visible = 1 AND b0_.create_at <= '2026-09-17 10:32:46' ORDER BY b0_.create_at DESC LIMIT 3;

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 = 50595 ORDER BY t0.main DESC, t0.id ASC;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.url AS url_2,
  b0_.description AS description_3,
  b0_.text AS text_4,
  b0_.keyword AS keyword_5,
  b0_.text_source AS text_source_6,
  b0_.visible AS visible_7,
  b0_.visible_homepage AS visible_homepage_8,
  b0_.create_at AS create_at_9,
  b0_.import_id AS import_id_10,
  b0_.top AS top_11,
  b0_.redirect AS redirect_12,
  b0_.main_kind_id AS main_kind_id_13,
  b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14,
  b0_.vehicle_model_id AS vehicle_model_id_15
FROM
  blog b0_
WHERE
  b0_.visible = 1
  AND b0_.visible_homepage = 1
  AND b0_.create_at <= ?
  AND b0_.id NOT IN (?, ?, ?)
ORDER BY
  b0_.create_at DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.url AS url_2, b0_.description AS description_3, b0_.text AS text_4, b0_.keyword AS keyword_5, b0_.text_source AS text_source_6, b0_.visible AS visible_7, b0_.visible_homepage AS visible_homepage_8, b0_.create_at AS create_at_9, b0_.import_id AS import_id_10, b0_.top AS top_11, b0_.redirect AS redirect_12, b0_.main_kind_id AS main_kind_id_13, b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14, b0_.vehicle_model_id AS vehicle_model_id_15 FROM blog b0_ WHERE b0_.visible = 1 AND b0_.visible_homepage = 1 AND b0_.create_at <= '2026-09-17 10:32:46' AND b0_.id NOT IN (5001, 4988, 4984) ORDER BY b0_.create_at DESC LIMIT 3;

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

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.url AS url_2,
  b0_.description AS description_3,
  b0_.text AS text_4,
  b0_.keyword AS keyword_5,
  b0_.text_source AS text_source_6,
  b0_.visible AS visible_7,
  b0_.visible_homepage AS visible_homepage_8,
  b0_.create_at AS create_at_9,
  b0_.import_id AS import_id_10,
  b0_.top AS top_11,
  b0_.redirect AS redirect_12,
  b0_.main_kind_id AS main_kind_id_13,
  b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14,
  b0_.vehicle_model_id AS vehicle_model_id_15
FROM
  blog b0_
WHERE
  b0_.visible <> 0
  AND b0_.top = 1
ORDER BY
  b0_.create_at DESC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.url AS url_2, b0_.description AS description_3, b0_.text AS text_4, b0_.keyword AS keyword_5, b0_.text_source AS text_source_6, b0_.visible AS visible_7, b0_.visible_homepage AS visible_homepage_8, b0_.create_at AS create_at_9, b0_.import_id AS import_id_10, b0_.top AS top_11, b0_.redirect AS redirect_12, b0_.main_kind_id AS main_kind_id_13, b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14, b0_.vehicle_model_id AS vehicle_model_id_15 FROM blog b0_ WHERE b0_.visible <> 0 AND b0_.top = 1 ORDER BY b0_.create_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4
FROM
  vehicle_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = 976;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.main AS main_3,
  t0.blog_id AS blog_id_4
FROM
  blog_image t0
WHERE
  t0.blog_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.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = 5001 ORDER BY t0.main DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3
FROM
  vehicle_manufacturer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = 154;

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  vehicle v0_
  INNER JOIN vehicle_kind v1_ ON v0_.kind_id = v1_.id
  INNER JOIN dealer d2_ ON v0_.dealer_id = d2_.id
WHERE
  v0_.visible = 1
  AND d2_.visible = 1
  AND v1_.url IN (?, ?, ?, ?, ?)
  AND v0_.first_seen_at >= ?

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ INNER JOIN vehicle_kind v1_ ON v0_.kind_id = v1_.id INNER JOIN dealer d2_ ON v0_.dealer_id = d2_.id WHERE v0_.visible = 1 AND d2_.visible = 1 AND v1_.url IN ('osobni-vozidla', 'uzitkova-vozidla', 'nakladni-vozidla', 'obytna-vozidla', 'motorky-skutry') AND v0_.first_seen_at >= '2026-09-17 00:00:00';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3
FROM
  blog_kind t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM blog_kind t0 WHERE t0.id = 2;

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 10:32:46' AND ((a2_.id IS NULL OR (a2_.valid_from <= '2026-09-17 10:32:46' AND a2_.valid_to >= '2026-09-17 10:32:46')));

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
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.url AS url_2,
  p0_.logo AS logo_3,
  p0_.autanet_partner_id AS autanet_partner_id_4
FROM
  partner p0_
  INNER JOIN autanet_partner a1_ ON p0_.autanet_partner_id = a1_.id
WHERE
  a1_.valid_from <= ?
  AND a1_.valid_to >= ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.url AS url_2, p0_.logo AS logo_3, p0_.autanet_partner_id AS autanet_partner_id_4 FROM partner p0_ INNER JOIN autanet_partner a1_ ON p0_.autanet_partner_id = a1_.id WHERE a1_.valid_from <= '2026-09-17 10:32:46' AND a1_.valid_to >= '2026-09-17 10:32:46';

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  dealer d0_
WHERE
  d0_.visible = 1
  AND (
    (
      d0_.basic_advertising IS NULL
      OR d0_.basic_advertising = 0
    )
  )

SELECT COUNT(d0_.id) AS sclr_0 FROM dealer d0_ WHERE d0_.visible = 1 AND ((d0_.basic_advertising IS NULL OR d0_.basic_advertising = 0));