Symfony Profiler

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
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 FROM vehicle_tip t0 WHERE t0.vehicle_id = 56019;

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 = 56187 ORDER BY t0.main DESC, t0.id 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_.seo_slug AS seo_slug_5,
  v0_.seo_title AS seo_title_6,
  v0_.seo_description AS seo_description_7,
  v0_.seo_h1 AS seo_h1_8,
  v0_.url_generated_at AS url_generated_at_9,
  v0_.vin AS vin_10,
  v0_.places AS places_11,
  v0_.doors AS doors_12,
  v0_.load_capacity AS load_capacity_13,
  v0_.total_weight AS total_weight_14,
  v0_.state AS state_15,
  v0_.mileage AS mileage_16,
  v0_.mileage_unit AS mileage_unit_17,
  v0_.made_date AS made_date_18,
  v0_.price AS price_19,
  v0_.vat AS vat_20,
  v0_.price_before AS price_before_21,
  v0_.price_leasing AS price_leasing_22,
  v0_.payment_leasing_count AS payment_leasing_count_23,
  v0_.eco_vat AS eco_vat_24,
  v0_.engine_volume AS engine_volume_25,
  v0_.stk_to AS stk_to_26,
  v0_.first_owner AS first_owner_27,
  v0_.service_book AS service_book_28,
  v0_.tuning AS tuning_29,
  v0_.note AS note_30,
  v0_.engine_power AS engine_power_31,
  v0_.type AS type_32,
  v0_.not_crashed AS not_crashed_33,
  v0_.financial_info AS financial_info_34,
  v0_.payment_leasing AS payment_leasing_35,
  v0_.gearbox AS gearbox_36,
  v0_.category_id AS category_id_37,
  v0_.kind_id AS kind_id_38,
  v0_.sub_kind_id AS sub_kind_id_39,
  v0_.model_id AS model_id_40,
  v0_.body_id AS body_id_41,
  v0_.color_id AS color_id_42,
  v0_.fuel_id AS fuel_id_43,
  v0_.condition_vehicle_id AS condition_vehicle_id_44,
  v0_.part_kind_id AS part_kind_id_45,
  v0_.manufacturer_id AS manufacturer_id_46,
  v0_.dealer_id AS dealer_id_47
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_.dealer_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

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_.seo_slug AS seo_slug_5, v0_.seo_title AS seo_title_6, v0_.seo_description AS seo_description_7, v0_.seo_h1 AS seo_h1_8, v0_.url_generated_at AS url_generated_at_9, v0_.vin AS vin_10, v0_.places AS places_11, v0_.doors AS doors_12, v0_.load_capacity AS load_capacity_13, v0_.total_weight AS total_weight_14, v0_.state AS state_15, v0_.mileage AS mileage_16, v0_.mileage_unit AS mileage_unit_17, v0_.made_date AS made_date_18, v0_.price AS price_19, v0_.vat AS vat_20, v0_.price_before AS price_before_21, v0_.price_leasing AS price_leasing_22, v0_.payment_leasing_count AS payment_leasing_count_23, v0_.eco_vat AS eco_vat_24, v0_.engine_volume AS engine_volume_25, v0_.stk_to AS stk_to_26, v0_.first_owner AS first_owner_27, v0_.service_book AS service_book_28, v0_.tuning AS tuning_29, v0_.note AS note_30, v0_.engine_power AS engine_power_31, v0_.type AS type_32, v0_.not_crashed AS not_crashed_33, v0_.financial_info AS financial_info_34, v0_.payment_leasing AS payment_leasing_35, v0_.gearbox AS gearbox_36, v0_.category_id AS category_id_37, v0_.kind_id AS kind_id_38, v0_.sub_kind_id AS sub_kind_id_39, v0_.model_id AS model_id_40, v0_.body_id AS body_id_41, v0_.color_id AS color_id_42, v0_.fuel_id AS fuel_id_43, v0_.condition_vehicle_id AS condition_vehicle_id_44, v0_.part_kind_id AS part_kind_id_45, v0_.manufacturer_id AS manufacturer_id_46, v0_.dealer_id AS dealer_id_47 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_.dealer_id = '264' 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.name AS name_2
FROM
  vehicle_fuel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_fuel t0 WHERE t0.id = 3;

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
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.url AS url_2
FROM
  vehicle_manufacturer v0_
  LEFT JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id
WHERE
  v1_.dealer_id = ?
  AND v1_.visible = 1
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_ LEFT JOIN vehicle v1_ ON v0_.id = v1_.manufacturer_id WHERE v1_.dealer_id = 264 AND v1_.visible = 1 ORDER BY v0_.name ASC;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_body t0 WHERE t0.id = 3;

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.url AS url_19,
  t0.opening_hours_note AS opening_hours_note_20,
  t0.district_id AS district_id_21
FROM
  dealer t0
WHERE
  t0.url = ?
LIMIT
  1

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.url AS url_19, t0.opening_hours_note AS opening_hours_note_20, t0.district_id AS district_id_21 FROM dealer t0 WHERE t0.url = 'auto-stodulky-3127' 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
WHERE
  v1_.dealer_id = ?
  AND v1_.visible = 1
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 WHERE v1_.dealer_id = 264 AND v1_.visible = 1 ORDER BY v0_.name ASC;