Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.uri AS uri_1,
  p0_.top_html AS top_html_2,
  p0_.bottom_html AS bottom_html_3,
  p0_.meta_title AS meta_title_4,
  p0_.meta_description AS meta_description_5,
  p0_.meta_keywords AS meta_keywords_6,
  p0_.page_heading AS page_heading_7,
  p0_.city_id AS city_id_8
FROM
  page_seo_texts p0_
WHERE
  p0_.uri = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = '/task-saloons-rotate/' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.country_code AS country_code_4,
  t0.city_group AS city_group_5,
  t0.timezone AS timezone_6,
  t0.map_latitude AS map_latitude_7,
  t0.map_longitude AS map_longitude_8
FROM
  cities t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.country_code AS country_code_4, t0.city_group AS city_group_5, t0.timezone AS timezone_6, t0.map_latitude AS map_latitude_7, t0.map_longitude AS map_longitude_8 FROM cities t0;

UPDATE
  saloon_adboard_placements
SET
  position = position + 1
WHERE
  saloon_id IN (
    SELECT
      id
    FROM
      saloons
    WHERE
      city_id = ?
  )
  AND position_group = ?

UPDATE saloon_adboard_placements SET position = position + 1 WHERE saloon_id IN (SELECT id FROM saloons WHERE city_id = 1) AND position_group = 50;

UPDATE
  saloon_adboard_placements
SET
  position = 1
WHERE
  saloon_id IN (
    SELECT
      id
    FROM
      saloons
    WHERE
      city_id = ?
  )
  AND position_group = ?
ORDER BY
  position DESC
LIMIT
  1

UPDATE saloon_adboard_placements SET position = 1 WHERE saloon_id IN (SELECT id FROM saloons WHERE city_id = 1) AND position_group = 50 ORDER BY position DESC LIMIT 1;

UPDATE
  saloon_adboard_placements
SET
  position = position + 1
WHERE
  saloon_id IN (
    SELECT
      id
    FROM
      saloons
    WHERE
      city_id = ?
  )
  AND position_group = ?

UPDATE saloon_adboard_placements SET position = position + 1 WHERE saloon_id IN (SELECT id FROM saloons WHERE city_id = 1) AND position_group = 30;

UPDATE
  saloon_adboard_placements
SET
  position = 1
WHERE
  saloon_id IN (
    SELECT
      id
    FROM
      saloons
    WHERE
      city_id = ?
  )
  AND position_group = ?
ORDER BY
  position DESC
LIMIT
  1

UPDATE saloon_adboard_placements SET position = 1 WHERE saloon_id IN (SELECT id FROM saloons WHERE city_id = 1) AND position_group = 30 ORDER BY position DESC LIMIT 1;

UPDATE
  saloon_adboard_placements
SET
  position = position + 1
WHERE
  saloon_id IN (
    SELECT
      id
    FROM
      saloons
    WHERE
      city_id = ?
  )
  AND position_group = ?

UPDATE saloon_adboard_placements SET position = position + 1 WHERE saloon_id IN (SELECT id FROM saloons WHERE city_id = 1) AND position_group = 100;

UPDATE
  saloon_adboard_placements
SET
  position = 1
WHERE
  saloon_id IN (
    SELECT
      id
    FROM
      saloons
    WHERE
      city_id = ?
  )
  AND position_group = ?
ORDER BY
  position DESC
LIMIT
  1

UPDATE saloon_adboard_placements SET position = 1 WHERE saloon_id IN (SELECT id FROM saloons WHERE city_id = 1) AND position_group = 100 ORDER BY position DESC LIMIT 1;

UPDATE
  saloon_adboard_placements
SET
  position = position + 1
WHERE
  saloon_id IN (
    SELECT
      id
    FROM
      saloons
    WHERE
      city_id = ?
  )
  AND position_group = ?

UPDATE saloon_adboard_placements SET position = position + 1 WHERE saloon_id IN (SELECT id FROM saloons WHERE city_id = 1) AND position_group = 200;

UPDATE
  saloon_adboard_placements
SET
  position = 1
WHERE
  saloon_id IN (
    SELECT
      id
    FROM
      saloons
    WHERE
      city_id = ?
  )
  AND position_group = ?
ORDER BY
  position DESC
LIMIT
  1

UPDATE saloon_adboard_placements SET position = 1 WHERE saloon_id IN (SELECT id FROM saloons WHERE city_id = 1) AND position_group = 200 ORDER BY position DESC LIMIT 1;