Symfony Profiler

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.external_id AS external_id_1,
  s0_.title AS title_2,
  s0_.description AS description_3,
  s0_.type AS type_4,
  s0_.min_image AS min_image_5,
  s0_.max_image AS max_image_6,
  s0_.feedback_id AS feedback_id_7,
  s0_.sort AS sort_8,
  s0_.disclaimer AS disclaimer_9,
  s0_.date_at AS date_at_10,
  s0_.date_to AS date_to_11,
  s0_.car_type AS car_type_12,
  s0_.marks_filter AS marks_filter_13
FROM
  special_offer s0_
  LEFT JOIN special_offer_city s2_ ON s0_.id = s2_.special_offer_id
  LEFT JOIN city c1_ ON c1_.id = s2_.city_id
WHERE
  c1_.id IN (?)
ORDER BY
  s0_.sort DESC,
  s0_.id DESC
LIMIT
  10

SELECT DISTINCT s0_.id AS id_0, s0_.external_id AS external_id_1, s0_.title AS title_2, s0_.description AS description_3, s0_.type AS type_4, s0_.min_image AS min_image_5, s0_.max_image AS max_image_6, s0_.feedback_id AS feedback_id_7, s0_.sort AS sort_8, s0_.disclaimer AS disclaimer_9, s0_.date_at AS date_at_10, s0_.date_to AS date_to_11, s0_.car_type AS car_type_12, s0_.marks_filter AS marks_filter_13 FROM special_offer s0_ LEFT JOIN special_offer_city s2_ ON s0_.id = s2_.special_offer_id LEFT JOIN city c1_ ON c1_.id = s2_.city_id WHERE c1_.id IN ('1') ORDER BY s0_.sort DESC, s0_.id DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11828;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN brand_city ON t0.id = brand_city.brand_id
WHERE
  brand_city.city_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN brand_city ON t0.id = brand_city.brand_id WHERE brand_city.city_id = 1;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id
WHERE
  special_offer_brand.special_offer_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id WHERE special_offer_brand.special_offer_id = 11828;

SELECT
  t0.id AS id_1,
  t0.poi_id AS poi_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.salon_time AS salon_time_8,
  t0.service_time AS service_time_9,
  t0.rating AS rating_10,
  t0.min_image AS min_image_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.timeslots AS timeslots_14,
  t0.external_id AS external_id_15,
  t0.city_id AS city_id_16,
  t0.brand_id AS brand_id_17
FROM
  dealer t0
  INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id
WHERE
  special_offer_dealer.special_offer_id = ?

SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id WHERE special_offer_dealer.special_offer_id = 11828;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11830;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id
WHERE
  special_offer_brand.special_offer_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id WHERE special_offer_brand.special_offer_id = 11830;

SELECT
  t0.id AS id_1,
  t0.poi_id AS poi_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.salon_time AS salon_time_8,
  t0.service_time AS service_time_9,
  t0.rating AS rating_10,
  t0.min_image AS min_image_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.timeslots AS timeslots_14,
  t0.external_id AS external_id_15,
  t0.city_id AS city_id_16,
  t0.brand_id AS brand_id_17
FROM
  dealer t0
  INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id
WHERE
  special_offer_dealer.special_offer_id = ?

SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id WHERE special_offer_dealer.special_offer_id = 11830;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11884;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id
WHERE
  special_offer_brand.special_offer_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id WHERE special_offer_brand.special_offer_id = 11884;

SELECT
  t0.id AS id_1,
  t0.poi_id AS poi_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.salon_time AS salon_time_8,
  t0.service_time AS service_time_9,
  t0.rating AS rating_10,
  t0.min_image AS min_image_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.timeslots AS timeslots_14,
  t0.external_id AS external_id_15,
  t0.city_id AS city_id_16,
  t0.brand_id AS brand_id_17
FROM
  dealer t0
  INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id
WHERE
  special_offer_dealer.special_offer_id = ?

SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id WHERE special_offer_dealer.special_offer_id = 11884;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11881;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id
WHERE
  special_offer_brand.special_offer_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id WHERE special_offer_brand.special_offer_id = 11881;

SELECT
  t0.id AS id_1,
  t0.poi_id AS poi_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.salon_time AS salon_time_8,
  t0.service_time AS service_time_9,
  t0.rating AS rating_10,
  t0.min_image AS min_image_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.timeslots AS timeslots_14,
  t0.external_id AS external_id_15,
  t0.city_id AS city_id_16,
  t0.brand_id AS brand_id_17
FROM
  dealer t0
  INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id
WHERE
  special_offer_dealer.special_offer_id = ?

SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id WHERE special_offer_dealer.special_offer_id = 11881;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11882;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id
WHERE
  special_offer_brand.special_offer_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id WHERE special_offer_brand.special_offer_id = 11882;

SELECT
  t0.id AS id_1,
  t0.poi_id AS poi_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.salon_time AS salon_time_8,
  t0.service_time AS service_time_9,
  t0.rating AS rating_10,
  t0.min_image AS min_image_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.timeslots AS timeslots_14,
  t0.external_id AS external_id_15,
  t0.city_id AS city_id_16,
  t0.brand_id AS brand_id_17
FROM
  dealer t0
  INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id
WHERE
  special_offer_dealer.special_offer_id = ?

SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id WHERE special_offer_dealer.special_offer_id = 11882;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11880;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id
WHERE
  special_offer_brand.special_offer_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id WHERE special_offer_brand.special_offer_id = 11880;

SELECT
  t0.id AS id_1,
  t0.poi_id AS poi_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.salon_time AS salon_time_8,
  t0.service_time AS service_time_9,
  t0.rating AS rating_10,
  t0.min_image AS min_image_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.timeslots AS timeslots_14,
  t0.external_id AS external_id_15,
  t0.city_id AS city_id_16,
  t0.brand_id AS brand_id_17
FROM
  dealer t0
  INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id
WHERE
  special_offer_dealer.special_offer_id = ?

SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id WHERE special_offer_dealer.special_offer_id = 11880;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11822;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id
WHERE
  special_offer_brand.special_offer_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id WHERE special_offer_brand.special_offer_id = 11822;

SELECT
  t0.id AS id_1,
  t0.poi_id AS poi_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.salon_time AS salon_time_8,
  t0.service_time AS service_time_9,
  t0.rating AS rating_10,
  t0.min_image AS min_image_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.timeslots AS timeslots_14,
  t0.external_id AS external_id_15,
  t0.city_id AS city_id_16,
  t0.brand_id AS brand_id_17
FROM
  dealer t0
  INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id
WHERE
  special_offer_dealer.special_offer_id = ?

SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id WHERE special_offer_dealer.special_offer_id = 11822;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11831;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id
WHERE
  special_offer_brand.special_offer_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id WHERE special_offer_brand.special_offer_id = 11831;

SELECT
  t0.id AS id_1,
  t0.poi_id AS poi_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.salon_time AS salon_time_8,
  t0.service_time AS service_time_9,
  t0.rating AS rating_10,
  t0.min_image AS min_image_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.timeslots AS timeslots_14,
  t0.external_id AS external_id_15,
  t0.city_id AS city_id_16,
  t0.brand_id AS brand_id_17
FROM
  dealer t0
  INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id
WHERE
  special_offer_dealer.special_offer_id = ?

SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id WHERE special_offer_dealer.special_offer_id = 11831;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11847;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id
WHERE
  special_offer_brand.special_offer_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN special_offer_brand ON t0.id = special_offer_brand.brand_id WHERE special_offer_brand.special_offer_id = 11847;

SELECT
  t0.id AS id_1,
  t0.poi_id AS poi_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.salon_time AS salon_time_8,
  t0.service_time AS service_time_9,
  t0.rating AS rating_10,
  t0.min_image AS min_image_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.timeslots AS timeslots_14,
  t0.external_id AS external_id_15,
  t0.city_id AS city_id_16,
  t0.brand_id AS brand_id_17
FROM
  dealer t0
  INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id
WHERE
  special_offer_dealer.special_offer_id = ?

SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 INNER JOIN special_offer_dealer ON t0.id = special_offer_dealer.dealer_id WHERE special_offer_dealer.special_offer_id = 11847;

SELECT
  t0.id AS id_1,
  t0.map AS map_2,
  t0.phone_number AS phone_number_3,
  t0.name AS name_4,
  t0.external_id AS external_id_5,
  t0.timezone AS timezone_6
FROM
  city t0
  INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id
WHERE
  special_offer_city.special_offer_id = ?

SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 INNER JOIN special_offer_city ON t0.id = special_offer_city.city_id WHERE special_offer_city.special_offer_id = 11833;