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/work_examples' 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/work_examples' ORDER BY t0.id DESC;

SELECT
  count(DISTINCT w0_.id) AS sclr_0
FROM
  work_example w0_
  INNER JOIN offer o1_ ON w0_.offer_id = o1_.id
  INNER JOIN work_example_location_relation w3_ ON w0_.id = w3_.work_example_id
  INNER JOIN geo_location g2_ ON g2_.id = w3_.location_id
  AND g2_.type IN ('1')
  INNER JOIN category2entity c5_ ON o1_.id = c5_.entity_id
  INNER JOIN category c4_ ON c4_.id = c5_.category_id
  AND c4_.type IN ('0')
WHERE
  o1_.active = ?
  AND o1_.hidden = ?
  AND (
    CURRENT_TIMESTAMP BETWEEN o1_.active_since
    AND o1_.active_till
  )
  AND c4_.id = ?
GROUP BY
  w0_.created_at,
  w0_.image_url,
  w0_.description,
  w0_.price,
  w0_.id,
  w0_.offer_id,
  w0_.beauty_master_id

SELECT count(DISTINCT w0_.id) AS sclr_0 FROM work_example w0_ INNER JOIN offer o1_ ON w0_.offer_id = o1_.id INNER JOIN work_example_location_relation w3_ ON w0_.id = w3_.work_example_id INNER JOIN geo_location g2_ ON g2_.id = w3_.location_id AND g2_.type IN ('1') INNER JOIN category2entity c5_ ON o1_.id = c5_.entity_id INNER JOIN category c4_ ON c4_.id = c5_.category_id AND c4_.type IN ('0') WHERE o1_.active = 1 AND o1_.hidden = 0 AND (CURRENT_TIMESTAMP BETWEEN o1_.active_since AND o1_.active_till) AND c4_.id = 54 GROUP BY w0_.created_at, w0_.image_url, w0_.description, w0_.price, w0_.id, w0_.offer_id, w0_.beauty_master_id;

SELECT
  DISTINCT w0_.id AS id_0,
  0 AS sclr_1
FROM
  work_example w0_
  INNER JOIN offer o1_ ON w0_.offer_id = o1_.id
  INNER JOIN work_example_location_relation w3_ ON w0_.id = w3_.work_example_id
  INNER JOIN geo_location g2_ ON g2_.id = w3_.location_id
  AND g2_.type IN ('1')
  INNER JOIN category2entity c5_ ON o1_.id = c5_.entity_id
  INNER JOIN category c4_ ON c4_.id = c5_.category_id
  AND c4_.type IN ('0')
WHERE
  o1_.active = ?
  AND o1_.hidden = ?
  AND (
    CURRENT_TIMESTAMP BETWEEN o1_.active_since
    AND o1_.active_till
  )
  AND c4_.id = ?
GROUP BY
  w0_.created_at,
  w0_.image_url,
  w0_.description,
  w0_.price,
  w0_.id,
  w0_.offer_id,
  w0_.beauty_master_id
ORDER BY
  sclr_1 DESC
LIMIT
  40

SELECT DISTINCT w0_.id AS id_0, 0 AS sclr_1 FROM work_example w0_ INNER JOIN offer o1_ ON w0_.offer_id = o1_.id INNER JOIN work_example_location_relation w3_ ON w0_.id = w3_.work_example_id INNER JOIN geo_location g2_ ON g2_.id = w3_.location_id AND g2_.type IN ('1') INNER JOIN category2entity c5_ ON o1_.id = c5_.entity_id INNER JOIN category c4_ ON c4_.id = c5_.category_id AND c4_.type IN ('0') WHERE o1_.active = 1 AND o1_.hidden = 0 AND (CURRENT_TIMESTAMP BETWEEN o1_.active_since AND o1_.active_till) AND c4_.id = 54 GROUP BY w0_.created_at, w0_.image_url, w0_.description, w0_.price, w0_.id, w0_.offer_id, w0_.beauty_master_id ORDER BY sclr_1 DESC LIMIT 40;