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_.last_modified AS last_modified_8,
  p0_.city_id AS city_id_9
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_.last_modified AS last_modified_8, p0_.city_id AS city_id_9 FROM page_seo_texts p0_ WHERE p0_.uri = '/task-rotate/' LIMIT 1;

SELECT
  GET_LOCK(?, ?)

SELECT GET_LOCK('sales:adboard:pipeline', 120);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.uri_identity AS uri_identity_2,
  c0_.country_code AS country_code_3,
  c0_.city_group AS city_group_4,
  c0_.city_price_category AS city_price_category_5,
  c0_.timezone AS timezone_6,
  c0_.region AS region_7,
  c0_.map_latitude AS map_latitude_8,
  c0_.map_longitude AS map_longitude_9
FROM
  cities c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uri_identity AS uri_identity_2, c0_.country_code AS country_code_3, c0_.city_group AS city_group_4, c0_.city_price_category AS city_price_category_5, c0_.timezone AS timezone_6, c0_.region AS region_7, c0_.map_latitude AS map_latitude_8, c0_.map_longitude AS map_longitude_9 FROM cities c0_;

SELECT
  COUNT(p0_.profile_id) AS sclr_0
FROM
  profile_adboard_placements p0_
  INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id
  AND p1_.placement_type IN (
    'standard_saloon', 'vip_saloon',
    'ultra_vip_saloon', 'standard_masseur',
    'vip_masseur', 'ultra_vip_masseur',
    'standard_profile', 'vip_profile',
    'ultra_vip_profile', 'top_profile',
    'placement_hiding'
  )
WHERE
  p1_.city_id = ?
  AND p0_.position_group = ?
  AND (
    p1_.placement_type IN (?)
    OR p1_.placement_type IN (?)
  )

SELECT COUNT(p0_.profile_id) AS sclr_0 FROM profile_adboard_placements p0_ INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id AND p1_.placement_type IN ('standard_saloon', 'vip_saloon', 'ultra_vip_saloon', 'standard_masseur', 'vip_masseur', 'ultra_vip_masseur', 'standard_profile', 'vip_profile', 'ultra_vip_profile', 'top_profile', 'placement_hiding') WHERE p1_.city_id = 1 AND p0_.position_group = 60 AND (p1_.placement_type IN ('standard_profile') OR p1_.placement_type IN ('standard_masseur'));

SELECT
  COUNT(p0_.profile_id) AS sclr_0
FROM
  profile_adboard_placements p0_
  INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id
  AND p1_.placement_type IN (
    'standard_saloon', 'vip_saloon',
    'ultra_vip_saloon', 'standard_masseur',
    'vip_masseur', 'ultra_vip_masseur',
    'standard_profile', 'vip_profile',
    'ultra_vip_profile', 'top_profile',
    'placement_hiding'
  )
WHERE
  p1_.city_id = ?
  AND p0_.position_group = ?
  AND (
    p1_.placement_type IN (?)
    OR p1_.placement_type IN (?)
  )

SELECT COUNT(p0_.profile_id) AS sclr_0 FROM profile_adboard_placements p0_ INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id AND p1_.placement_type IN ('standard_saloon', 'vip_saloon', 'ultra_vip_saloon', 'standard_masseur', 'vip_masseur', 'ultra_vip_masseur', 'standard_profile', 'vip_profile', 'ultra_vip_profile', 'top_profile', 'placement_hiding') WHERE p1_.city_id = 1 AND p0_.position_group = 50 AND (p1_.placement_type IN ('standard_profile') OR p1_.placement_type IN ('standard_masseur'));

SELECT
  COUNT(p0_.profile_id) AS sclr_0
FROM
  profile_adboard_placements p0_
  INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id
  AND p1_.placement_type IN (
    'standard_saloon', 'vip_saloon',
    'ultra_vip_saloon', 'standard_masseur',
    'vip_masseur', 'ultra_vip_masseur',
    'standard_profile', 'vip_profile',
    'ultra_vip_profile', 'top_profile',
    'placement_hiding'
  )
WHERE
  p1_.city_id = ?
  AND p0_.position_group = ?
  AND (
    p1_.placement_type IN (?)
    OR p1_.placement_type IN (?)
  )

SELECT COUNT(p0_.profile_id) AS sclr_0 FROM profile_adboard_placements p0_ INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id AND p1_.placement_type IN ('standard_saloon', 'vip_saloon', 'ultra_vip_saloon', 'standard_masseur', 'vip_masseur', 'ultra_vip_masseur', 'standard_profile', 'vip_profile', 'ultra_vip_profile', 'top_profile', 'placement_hiding') WHERE p1_.city_id = 1 AND p0_.position_group = 40 AND (p1_.placement_type IN ('standard_profile') OR p1_.placement_type IN ('standard_masseur'));

SELECT
  COUNT(p0_.profile_id) AS sclr_0
FROM
  profile_adboard_placements p0_
  INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id
  AND p1_.placement_type IN (
    'standard_saloon', 'vip_saloon',
    'ultra_vip_saloon', 'standard_masseur',
    'vip_masseur', 'ultra_vip_masseur',
    'standard_profile', 'vip_profile',
    'ultra_vip_profile', 'top_profile',
    'placement_hiding'
  )
WHERE
  p1_.city_id = ?
  AND p0_.position_group = ?
  AND (
    p1_.placement_type IN (?)
    OR p1_.placement_type IN (?)
  )

SELECT COUNT(p0_.profile_id) AS sclr_0 FROM profile_adboard_placements p0_ INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id AND p1_.placement_type IN ('standard_saloon', 'vip_saloon', 'ultra_vip_saloon', 'standard_masseur', 'vip_masseur', 'ultra_vip_masseur', 'standard_profile', 'vip_profile', 'ultra_vip_profile', 'top_profile', 'placement_hiding') WHERE p1_.city_id = 1 AND p0_.position_group = 30 AND (p1_.placement_type IN ('standard_profile') OR p1_.placement_type IN ('standard_masseur'));

SELECT
  COUNT(p0_.profile_id) AS sclr_0
FROM
  profile_adboard_placements p0_
  INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id
  AND p1_.placement_type IN (
    'standard_saloon', 'vip_saloon',
    'ultra_vip_saloon', 'standard_masseur',
    'vip_masseur', 'ultra_vip_masseur',
    'standard_profile', 'vip_profile',
    'ultra_vip_profile', 'top_profile',
    'placement_hiding'
  )
WHERE
  p1_.city_id = ?
  AND p0_.position_group = ?
  AND (
    p1_.placement_type IN (?)
    OR p1_.placement_type IN (?)
  )

SELECT COUNT(p0_.profile_id) AS sclr_0 FROM profile_adboard_placements p0_ INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id AND p1_.placement_type IN ('standard_saloon', 'vip_saloon', 'ultra_vip_saloon', 'standard_masseur', 'vip_masseur', 'ultra_vip_masseur', 'standard_profile', 'vip_profile', 'ultra_vip_profile', 'top_profile', 'placement_hiding') WHERE p1_.city_id = 1 AND p0_.position_group = 100 AND (p1_.placement_type IN ('vip_profile') OR p1_.placement_type IN ('vip_masseur'));

SELECT
  COUNT(p0_.profile_id) AS sclr_0
FROM
  profile_adboard_placements p0_
  INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id
  AND p1_.placement_type IN (
    'standard_saloon', 'vip_saloon',
    'ultra_vip_saloon', 'standard_masseur',
    'vip_masseur', 'ultra_vip_masseur',
    'standard_profile', 'vip_profile',
    'ultra_vip_profile', 'top_profile',
    'placement_hiding'
  )
WHERE
  p1_.city_id = ?
  AND p0_.position_group = ?
  AND (
    p1_.placement_type IN (?)
    OR p1_.placement_type IN (?)
  )

SELECT COUNT(p0_.profile_id) AS sclr_0 FROM profile_adboard_placements p0_ INNER JOIN paid_service_prices p1_ ON p0_.placement_price_id = p1_.id AND p1_.placement_type IN ('standard_saloon', 'vip_saloon', 'ultra_vip_saloon', 'standard_masseur', 'vip_masseur', 'ultra_vip_masseur', 'standard_profile', 'vip_profile', 'ultra_vip_profile', 'top_profile', 'placement_hiding') WHERE p1_.city_id = 1 AND p0_.position_group = 200 AND (p1_.placement_type IN ('ultra_vip_profile') OR p1_.placement_type IN ('ultra_vip_masseur'));

DO RELEASE_LOCK(?)

DO RELEASE_LOCK('sales:adboard:pipeline');

SELECT
  GET_LOCK(?, ?)

SELECT GET_LOCK('sales:adboard:pipeline', 120);

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.city_price_category AS city_price_category_6,
  t0.timezone AS timezone_7,
  t0.region AS region_8,
  t0.map_latitude AS map_latitude_9,
  t0.map_longitude AS map_longitude_10
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.city_price_category AS city_price_category_6, t0.timezone AS timezone_7, t0.region AS region_8, t0.map_latitude AS map_latitude_9, t0.map_longitude AS map_longitude_10 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;

DO RELEASE_LOCK(?)

DO RELEASE_LOCK('sales:adboard:pipeline');