Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.thumb AS thumb_2,
  c0_.path AS path_3,
  (
    CASE WHEN c0_.category_id IS NULL THEN
      0
    ELSE
      (c0_.category_id)
    END
  ) AS sclr_4,
  COUNT(c1_.id) AS sclr_5
FROM
  category c0_
  LEFT JOIN category c2_ ON c0_.category_id = c2_.id
  LEFT JOIN classified_category c3_ ON c0_.id = c3_.category_id
  LEFT JOIN classified c1_ ON c1_.id = c3_.classified_id
  AND (c1_.active = 1)
WHERE
  c0_.category_id IS NULL
  OR (
    c2_.id = c0_.category_id
    AND c2_.category_id IS NULL
  )
GROUP BY
  c0_.id
ORDER BY
  c0_.position ASC,
  c2_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.thumb AS thumb_2, c0_.path AS path_3, (CASE WHEN c0_.category_id IS NULL THEN 0 ELSE (c0_.category_id) END) AS sclr_4, COUNT(c1_.id) AS sclr_5 FROM category c0_ LEFT JOIN category c2_ ON c0_.category_id = c2_.id LEFT JOIN classified_category c3_ ON c0_.id = c3_.category_id LEFT JOIN classified c1_ ON c1_.id = c3_.classified_id AND (c1_.active = 1) WHERE c0_.category_id IS NULL OR (c2_.id = c0_.category_id AND c2_.category_id IS NULL) GROUP BY c0_.id ORDER BY c0_.position ASC, c2_.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.path AS path_4,
  t0.position AS position_5,
  t0.region_id AS region_id_6
FROM
  region t0
WHERE
  t0.region_id IS NULL
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.path AS path_4, t0.position AS position_5, t0.region_id AS region_id_6 FROM region t0 WHERE t0.region_id IS NULL ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.thumb AS thumb_4,
  t0.content AS content_5,
  t0.lid AS lid_6,
  t0.description AS description_7,
  t0.keywords AS keywords_8,
  t0.date AS date_9,
  t0.view_count AS view_count_10,
  t0.user_id AS user_id_11
FROM
  blog t0
ORDER BY
  t0.date DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.thumb AS thumb_4, t0.content AS content_5, t0.lid AS lid_6, t0.description AS description_7, t0.keywords AS keywords_8, t0.date AS date_9, t0.view_count AS view_count_10, t0.user_id AS user_id_11 FROM blog t0 ORDER BY t0.date DESC LIMIT 4;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          (
            CASE WHEN c0_.promoted = 1 THEN
              c0_.promoted_date_start
            ELSE
              0
            END
          ) AS sclr_0,
          c0_.id AS id_1,
          c0_.name AS name_2,
          c0_.slug AS slug_3,
          c0_.price AS price_4,
          c0_.price_negotiate AS price_negotiate_5,
          c0_.phone AS phone_6,
          c0_.email AS email_7,
          c0_.description AS description_8,
          c0_.active AS active_9,
          c0_.code AS code_10,
          c0_.ip AS ip_11,
          c0_.date_start AS date_start_12,
          c0_.date_finish AS date_finish_13,
          c0_.date AS date_14,
          c0_.address AS address_15,
          c0_.promoted AS promoted_16,
          c0_.promoted_date_start AS promoted_date_start_17,
          c0_.promoted_date_finish AS promoted_date_finish_18,
          c0_.email_confirmed AS email_confirmed_19,
          c0_.admin_confirmed AS admin_confirmed_20,
          c0_.facebook_url AS facebook_url_21,
          c0_.phone_view_count AS phone_view_count_22,
          c0_.email_view_count AS email_view_count_23,
          c0_.video AS video_24,
          c0_.show_map AS show_map_25,
          p1_.id AS id_26,
          p1_.position AS position_27,
          p1_.folder AS folder_28,
          p1_.filename AS filename_29,
          p1_.date AS date_30,
          r2_.id AS id_31,
          r2_.name AS name_32,
          r2_.slug AS slug_33,
          r2_.path AS path_34,
          r2_.position AS position_35
        FROM
          classified c0_
          LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id
          LEFT JOIN classified_region c3_ ON c0_.id = c3_.classified_id
          LEFT JOIN region r2_ ON r2_.id = c3_.region_id
        WHERE
          c0_.active = 1
        ORDER BY
          sclr_0 DESC,
          c0_.date_start DESC,
          p1_.position ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT (CASE WHEN c0_.promoted = 1 THEN c0_.promoted_date_start ELSE 0 END) AS sclr_0, c0_.id AS id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.price AS price_4, c0_.price_negotiate AS price_negotiate_5, c0_.phone AS phone_6, c0_.email AS email_7, c0_.description AS description_8, c0_.active AS active_9, c0_.code AS code_10, c0_.ip AS ip_11, c0_.date_start AS date_start_12, c0_.date_finish AS date_finish_13, c0_.date AS date_14, c0_.address AS address_15, c0_.promoted AS promoted_16, c0_.promoted_date_start AS promoted_date_start_17, c0_.promoted_date_finish AS promoted_date_finish_18, c0_.email_confirmed AS email_confirmed_19, c0_.admin_confirmed AS admin_confirmed_20, c0_.facebook_url AS facebook_url_21, c0_.phone_view_count AS phone_view_count_22, c0_.email_view_count AS email_view_count_23, c0_.video AS video_24, c0_.show_map AS show_map_25, p1_.id AS id_26, p1_.position AS position_27, p1_.folder AS folder_28, p1_.filename AS filename_29, p1_.date AS date_30, r2_.id AS id_31, r2_.name AS name_32, r2_.slug AS slug_33, r2_.path AS path_34, r2_.position AS position_35 FROM classified c0_ LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id LEFT JOIN classified_region c3_ ON c0_.id = c3_.classified_id LEFT JOIN region r2_ ON r2_.id = c3_.region_id WHERE c0_.active = 1 ORDER BY sclr_0 DESC, c0_.date_start DESC, p1_.position ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_1
FROM
  (
    SELECT
      DISTINCT id_1,
      sclr_0,
      date_start_12
    FROM
      (
        SELECT
          (
            CASE WHEN c0_.promoted = 1 THEN
              c0_.promoted_date_start
            ELSE
              0
            END
          ) AS sclr_0,
          c0_.id AS id_1,
          c0_.name AS name_2,
          c0_.slug AS slug_3,
          c0_.price AS price_4,
          c0_.price_negotiate AS price_negotiate_5,
          c0_.phone AS phone_6,
          c0_.email AS email_7,
          c0_.description AS description_8,
          c0_.active AS active_9,
          c0_.code AS code_10,
          c0_.ip AS ip_11,
          c0_.date_start AS date_start_12,
          c0_.date_finish AS date_finish_13,
          c0_.date AS date_14,
          c0_.address AS address_15,
          c0_.promoted AS promoted_16,
          c0_.promoted_date_start AS promoted_date_start_17,
          c0_.promoted_date_finish AS promoted_date_finish_18,
          c0_.email_confirmed AS email_confirmed_19,
          c0_.admin_confirmed AS admin_confirmed_20,
          c0_.facebook_url AS facebook_url_21,
          c0_.phone_view_count AS phone_view_count_22,
          c0_.email_view_count AS email_view_count_23,
          c0_.video AS video_24,
          c0_.show_map AS show_map_25,
          p1_.id AS id_26,
          p1_.position AS position_27,
          p1_.folder AS folder_28,
          p1_.filename AS filename_29,
          p1_.date AS date_30,
          r2_.id AS id_31,
          r2_.name AS name_32,
          r2_.slug AS slug_33,
          r2_.path AS path_34,
          r2_.position AS position_35
        FROM
          classified c0_
          LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id
          LEFT JOIN classified_region c3_ ON c0_.id = c3_.classified_id
          LEFT JOIN region r2_ ON r2_.id = c3_.region_id
        WHERE
          c0_.active = 1
        ORDER BY
          p1_.position ASC
      ) dctrn_result_inner
    ORDER BY
      sclr_0 DESC,
      date_start_12 DESC
  ) dctrn_result
LIMIT
  48

SELECT DISTINCT id_1 FROM (SELECT DISTINCT id_1, sclr_0, date_start_12 FROM (SELECT (CASE WHEN c0_.promoted = 1 THEN c0_.promoted_date_start ELSE 0 END) AS sclr_0, c0_.id AS id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.price AS price_4, c0_.price_negotiate AS price_negotiate_5, c0_.phone AS phone_6, c0_.email AS email_7, c0_.description AS description_8, c0_.active AS active_9, c0_.code AS code_10, c0_.ip AS ip_11, c0_.date_start AS date_start_12, c0_.date_finish AS date_finish_13, c0_.date AS date_14, c0_.address AS address_15, c0_.promoted AS promoted_16, c0_.promoted_date_start AS promoted_date_start_17, c0_.promoted_date_finish AS promoted_date_finish_18, c0_.email_confirmed AS email_confirmed_19, c0_.admin_confirmed AS admin_confirmed_20, c0_.facebook_url AS facebook_url_21, c0_.phone_view_count AS phone_view_count_22, c0_.email_view_count AS email_view_count_23, c0_.video AS video_24, c0_.show_map AS show_map_25, p1_.id AS id_26, p1_.position AS position_27, p1_.folder AS folder_28, p1_.filename AS filename_29, p1_.date AS date_30, r2_.id AS id_31, r2_.name AS name_32, r2_.slug AS slug_33, r2_.path AS path_34, r2_.position AS position_35 FROM classified c0_ LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id LEFT JOIN classified_region c3_ ON c0_.id = c3_.classified_id LEFT JOIN region r2_ ON r2_.id = c3_.region_id WHERE c0_.active = 1 ORDER BY p1_.position ASC) dctrn_result_inner ORDER BY sclr_0 DESC, date_start_12 DESC) dctrn_result LIMIT 48;

SELECT
  (
    CASE WHEN c0_.promoted = 1 THEN
      c0_.promoted_date_start
    ELSE
      0
    END
  ) AS sclr_0,
  c0_.id AS id_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.price AS price_4,
  c0_.price_negotiate AS price_negotiate_5,
  c0_.phone AS phone_6,
  c0_.email AS email_7,
  c0_.description AS description_8,
  c0_.active AS active_9,
  c0_.code AS code_10,
  c0_.ip AS ip_11,
  c0_.date_start AS date_start_12,
  c0_.date_finish AS date_finish_13,
  c0_.date AS date_14,
  c0_.address AS address_15,
  c0_.promoted AS promoted_16,
  c0_.promoted_date_start AS promoted_date_start_17,
  c0_.promoted_date_finish AS promoted_date_finish_18,
  c0_.email_confirmed AS email_confirmed_19,
  c0_.admin_confirmed AS admin_confirmed_20,
  c0_.facebook_url AS facebook_url_21,
  c0_.phone_view_count AS phone_view_count_22,
  c0_.email_view_count AS email_view_count_23,
  c0_.video AS video_24,
  c0_.show_map AS show_map_25,
  p1_.id AS id_26,
  p1_.position AS position_27,
  p1_.folder AS folder_28,
  p1_.filename AS filename_29,
  p1_.date AS date_30,
  r2_.id AS id_31,
  r2_.name AS name_32,
  r2_.slug AS slug_33,
  r2_.path AS path_34,
  r2_.position AS position_35,
  c0_.user_id AS user_id_36,
  c0_.duration_id AS duration_id_37,
  c0_.promote_duration_id AS promote_duration_id_38,
  p1_.user_id AS user_id_39,
  p1_.classified_id AS classified_id_40,
  r2_.region_id AS region_id_41
FROM
  classified c0_
  LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id
  LEFT JOIN classified_region c3_ ON c0_.id = c3_.classified_id
  LEFT JOIN region r2_ ON r2_.id = c3_.region_id
WHERE
  c0_.active = 1
  AND c0_.id IN (?, ?)
ORDER BY
  sclr_0 DESC,
  c0_.date_start DESC,
  p1_.position ASC

SELECT (CASE WHEN c0_.promoted = 1 THEN c0_.promoted_date_start ELSE 0 END) AS sclr_0, c0_.id AS id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.price AS price_4, c0_.price_negotiate AS price_negotiate_5, c0_.phone AS phone_6, c0_.email AS email_7, c0_.description AS description_8, c0_.active AS active_9, c0_.code AS code_10, c0_.ip AS ip_11, c0_.date_start AS date_start_12, c0_.date_finish AS date_finish_13, c0_.date AS date_14, c0_.address AS address_15, c0_.promoted AS promoted_16, c0_.promoted_date_start AS promoted_date_start_17, c0_.promoted_date_finish AS promoted_date_finish_18, c0_.email_confirmed AS email_confirmed_19, c0_.admin_confirmed AS admin_confirmed_20, c0_.facebook_url AS facebook_url_21, c0_.phone_view_count AS phone_view_count_22, c0_.email_view_count AS email_view_count_23, c0_.video AS video_24, c0_.show_map AS show_map_25, p1_.id AS id_26, p1_.position AS position_27, p1_.folder AS folder_28, p1_.filename AS filename_29, p1_.date AS date_30, r2_.id AS id_31, r2_.name AS name_32, r2_.slug AS slug_33, r2_.path AS path_34, r2_.position AS position_35, c0_.user_id AS user_id_36, c0_.duration_id AS duration_id_37, c0_.promote_duration_id AS promote_duration_id_38, p1_.user_id AS user_id_39, p1_.classified_id AS classified_id_40, r2_.region_id AS region_id_41 FROM classified c0_ LEFT JOIN photo p1_ ON c0_.id = p1_.classified_id LEFT JOIN classified_region c3_ ON c0_.id = c3_.classified_id LEFT JOIN region r2_ ON r2_.id = c3_.region_id WHERE c0_.active = 1 AND c0_.id IN (386, 354) ORDER BY sclr_0 DESC, c0_.date_start DESC, p1_.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.content AS content_5,
  t0.description AS description_6,
  t0.keywords AS keywords_7,
  t0.contact_form AS contact_form_8,
  t0.in_footer AS in_footer_9
FROM
  static_page t0
WHERE
  t0.in_footer = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.content AS content_5, t0.description AS description_6, t0.keywords AS keywords_7, t0.contact_form AS contact_form_8, t0.in_footer AS in_footer_9 FROM static_page t0 WHERE t0.in_footer = 1 ORDER BY t0.position ASC;