Symfony Profiler

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.domain = ?
  AND t0.main_alias = ?
  AND t0.active = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = 'www' AND t0.main_alias = '/mobile/api/v2/beauty/offer/126066/masters_with_filter' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.main_alias = ?
ORDER BY
  t0.id DESC

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = '/mobile/api/v2/beauty/offer/126066/masters_with_filter' ORDER BY t0.id DESC;

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  beauty_master b0_
  INNER JOIN beauty_master_location b2_ ON b0_.id = b2_.master_id
  INNER JOIN geo_location g1_ ON g1_.id = b2_.location_id
  AND g1_.type IN ('1')
WHERE
  g1_.id IN (
    SELECT
      g3_.id
    FROM
      geo_location g3_
      INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id
      INNER JOIN offer o4_ ON o4_.id = g5_.entity_id
    WHERE
      (o4_.id = ?)
      AND g3_.type IN ('1')
  )
  AND b0_.position IS NULL
GROUP BY
  b0_.id

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM beauty_master b0_ INNER JOIN beauty_master_location b2_ ON b0_.id = b2_.master_id INNER JOIN geo_location g1_ ON g1_.id = b2_.location_id AND g1_.type IN ('1') WHERE g1_.id IN (SELECT g3_.id FROM geo_location g3_ INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id INNER JOIN offer o4_ ON o4_.id = g5_.entity_id WHERE (o4_.id = 126066) AND g3_.type IN ('1')) AND b0_.position IS NULL GROUP BY b0_.id;

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.id AS id_1
FROM
  beauty_master b0_
  INNER JOIN beauty_master_location b2_ ON b0_.id = b2_.master_id
  INNER JOIN geo_location g1_ ON g1_.id = b2_.location_id
  AND g1_.type IN ('1')
WHERE
  g1_.id IN (
    SELECT
      g3_.id
    FROM
      geo_location g3_
      INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id
      INNER JOIN offer o4_ ON o4_.id = g5_.entity_id
    WHERE
      (o4_.id = ?)
      AND g3_.type IN ('1')
  )
  AND b0_.position IS NULL
GROUP BY
  b0_.id
ORDER BY
  b0_.id ASC
LIMIT
  20

SELECT DISTINCT b0_.id AS id_0, b0_.id AS id_1 FROM beauty_master b0_ INNER JOIN beauty_master_location b2_ ON b0_.id = b2_.master_id INNER JOIN geo_location g1_ ON g1_.id = b2_.location_id AND g1_.type IN ('1') WHERE g1_.id IN (SELECT g3_.id FROM geo_location g3_ INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id INNER JOIN offer o4_ ON o4_.id = g5_.entity_id WHERE (o4_.id = 126066) AND g3_.type IN ('1')) AND b0_.position IS NULL GROUP BY b0_.id ORDER BY b0_.id ASC LIMIT 20;