Symfony Profiler

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-dejvice-3126' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.summer AS summer_3,
  t0.description AS description_4,
  t0.dealer_id AS dealer_id_5
FROM
  dealer_open_hour t0
WHERE
  t0.dealer_id = ?
  AND t0.summer = ?

SELECT t0.id AS id_1, t0.day AS day_2, t0.summer AS summer_3, t0.description AS description_4, t0.dealer_id AS dealer_id_5 FROM dealer_open_hour t0 WHERE t0.dealer_id = 263 AND t0.summer = '0';

SELECT
  t0.id AS id_1,
  t0.id_import AS id_import_2,
  t0.visible AS visible_3,
  t0.create_at AS create_at_4,
  t0.hidden_at AS hidden_at_5,
  t0.seo_slug AS seo_slug_6,
  t0.seo_title AS seo_title_7,
  t0.seo_description AS seo_description_8,
  t0.seo_h1 AS seo_h1_9,
  t0.url_generated_at AS url_generated_at_10,
  t0.vin AS vin_11,
  t0.places AS places_12,
  t0.doors AS doors_13,
  t0.load_capacity AS load_capacity_14,
  t0.total_weight AS total_weight_15,
  t0.state AS state_16,
  t0.mileage AS mileage_17,
  t0.mileage_unit AS mileage_unit_18,
  t0.made_date AS made_date_19,
  t0.price AS price_20,
  t0.vat AS vat_21,
  t0.price_before AS price_before_22,
  t0.price_leasing AS price_leasing_23,
  t0.payment_leasing_count AS payment_leasing_count_24,
  t0.eco_vat AS eco_vat_25,
  t0.engine_volume AS engine_volume_26,
  t0.stk_to AS stk_to_27,
  t0.first_owner AS first_owner_28,
  t0.service_book AS service_book_29,
  t0.tuning AS tuning_30,
  t0.note AS note_31,
  t0.engine_power AS engine_power_32,
  t0.type AS type_33,
  t0.not_crashed AS not_crashed_34,
  t0.financial_info AS financial_info_35,
  t0.payment_leasing AS payment_leasing_36,
  t0.gearbox AS gearbox_37,
  t0.category_id AS category_id_38,
  t0.kind_id AS kind_id_39,
  t0.sub_kind_id AS sub_kind_id_40,
  t0.model_id AS model_id_41,
  t0.body_id AS body_id_42,
  t0.color_id AS color_id_43,
  t0.fuel_id AS fuel_id_44,
  t0.condition_vehicle_id AS condition_vehicle_id_45,
  t0.part_kind_id AS part_kind_id_46,
  t0.manufacturer_id AS manufacturer_id_47,
  t48.id AS id_49,
  t48.create_at AS create_at_50,
  t48.end_at AS end_at_51,
  t48.vehicle_id AS vehicle_id_52,
  t0.dealer_id AS dealer_id_53
FROM
  vehicle t0
  LEFT JOIN vehicle_tip t48 ON t48.vehicle_id = t0.id
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?
ORDER BY
  t0.create_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.id_import AS id_import_2, t0.visible AS visible_3, t0.create_at AS create_at_4, t0.hidden_at AS hidden_at_5, t0.seo_slug AS seo_slug_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_h1 AS seo_h1_9, t0.url_generated_at AS url_generated_at_10, t0.vin AS vin_11, t0.places AS places_12, t0.doors AS doors_13, t0.load_capacity AS load_capacity_14, t0.total_weight AS total_weight_15, t0.state AS state_16, t0.mileage AS mileage_17, t0.mileage_unit AS mileage_unit_18, t0.made_date AS made_date_19, t0.price AS price_20, t0.vat AS vat_21, t0.price_before AS price_before_22, t0.price_leasing AS price_leasing_23, t0.payment_leasing_count AS payment_leasing_count_24, t0.eco_vat AS eco_vat_25, t0.engine_volume AS engine_volume_26, t0.stk_to AS stk_to_27, t0.first_owner AS first_owner_28, t0.service_book AS service_book_29, t0.tuning AS tuning_30, t0.note AS note_31, t0.engine_power AS engine_power_32, t0.type AS type_33, t0.not_crashed AS not_crashed_34, t0.financial_info AS financial_info_35, t0.payment_leasing AS payment_leasing_36, t0.gearbox AS gearbox_37, t0.category_id AS category_id_38, t0.kind_id AS kind_id_39, t0.sub_kind_id AS sub_kind_id_40, t0.model_id AS model_id_41, t0.body_id AS body_id_42, t0.color_id AS color_id_43, t0.fuel_id AS fuel_id_44, t0.condition_vehicle_id AS condition_vehicle_id_45, t0.part_kind_id AS part_kind_id_46, t0.manufacturer_id AS manufacturer_id_47, t48.id AS id_49, t48.create_at AS create_at_50, t48.end_at AS end_at_51, t48.vehicle_id AS vehicle_id_52, t0.dealer_id AS dealer_id_53 FROM vehicle t0 LEFT JOIN vehicle_tip t48 ON t48.vehicle_id = t0.id WHERE t0.dealer_id = 263 AND t0.visible = 1 ORDER BY t0.create_at DESC LIMIT 5;

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
WHERE
  t0.id = ?

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 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4 FROM region t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.dealer_id AS dealer_id_3
FROM
  dealer_phone t0
WHERE
  t0.dealer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.dealer_id AS dealer_id_3 FROM dealer_phone t0 WHERE t0.dealer_id = 263;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.main AS main_3,
  t0.dealer_id AS dealer_id_4
FROM
  dealer_image t0
WHERE
  t0.dealer_id = ?
ORDER BY
  t0.main DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.dealer_id AS dealer_id_4 FROM dealer_image t0 WHERE t0.dealer_id = 263 ORDER BY t0.main DESC;

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 = 56448 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 = 3;

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

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

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

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 = 56377 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.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 = 56395 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.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 = 56265 ORDER BY t0.main DESC, t0.id 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.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 = 12;

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

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

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.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;