Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.category AS category_1,
          e0_.title AS title_2,
          e0_.main_image AS main_image_3,
          e0_.thumbnail AS thumbnail_4,
          e0_.summary_title AS summary_title_5,
          e0_.summary_content AS summary_content_6,
          e0_.pickup_content_description AS pickup_content_description_7,
          e0_.title_en AS title_en_8,
          e0_.title_cn AS title_cn_9,
          e0_.summary_title_en AS summary_title_en_10,
          e0_.summary_title_cn AS summary_title_cn_11,
          e0_.summary_content_en AS summary_content_en_12,
          e0_.summary_content_cn AS summary_content_cn_13,
          e0_.pickup_contents_description_en AS pickup_contents_description_en_14,
          e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15,
          e0_.title_tw AS title_tw_16,
          e0_.summary_title_tw AS summary_title_tw_17,
          e0_.summary_content_tw AS summary_content_tw_18,
          e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19,
          e0_.add_life_experience AS add_life_experience_20,
          e0_.life_experience_thumbnail AS life_experience_thumbnail_21,
          e0_.is_draft AS is_draft_22,
          e0_.approval AS approval_23,
          e0_.created_at AS created_at_24,
          e0_.updated_at AS updated_at_25,
          e0_.deleted_at AS deleted_at_26
        FROM
          entry_entry e0_
          LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id)
          AND (a1_.deleted_at IS NULL)
          LEFT JOIN mst_area m2_ ON (e0_.area_id = m2_.id)
          AND (m2_.deleted_at IS NULL)
          LEFT JOIN entry_modelplan e3_ ON (e0_.id = e3_.entry_id)
          AND (e3_.deleted_at IS NULL)
        WHERE
          (
            e0_.category = ?
            AND e0_.approval = ?
            AND e0_.is_draft = ?
            AND a1_.status = ?
            AND e0_.category = ?
          )
          AND (e0_.deleted_at IS NULL)
        ORDER BY
          RAND() ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.category AS category_1, e0_.title AS title_2, e0_.main_image AS main_image_3, e0_.thumbnail AS thumbnail_4, e0_.summary_title AS summary_title_5, e0_.summary_content AS summary_content_6, e0_.pickup_content_description AS pickup_content_description_7, e0_.title_en AS title_en_8, e0_.title_cn AS title_cn_9, e0_.summary_title_en AS summary_title_en_10, e0_.summary_title_cn AS summary_title_cn_11, e0_.summary_content_en AS summary_content_en_12, e0_.summary_content_cn AS summary_content_cn_13, e0_.pickup_contents_description_en AS pickup_contents_description_en_14, e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15, e0_.title_tw AS title_tw_16, e0_.summary_title_tw AS summary_title_tw_17, e0_.summary_content_tw AS summary_content_tw_18, e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19, e0_.add_life_experience AS add_life_experience_20, e0_.life_experience_thumbnail AS life_experience_thumbnail_21, e0_.is_draft AS is_draft_22, e0_.approval AS approval_23, e0_.created_at AS created_at_24, e0_.updated_at AS updated_at_25, e0_.deleted_at AS deleted_at_26 FROM entry_entry e0_ LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id) AND (a1_.deleted_at IS NULL) LEFT JOIN mst_area m2_ ON (e0_.area_id = m2_.id) AND (m2_.deleted_at IS NULL) LEFT JOIN entry_modelplan e3_ ON (e0_.id = e3_.entry_id) AND (e3_.deleted_at IS NULL) WHERE (e0_.category = 1 AND e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1 AND e0_.category = 1) AND (e0_.deleted_at IS NULL) ORDER BY RAND() ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      RAND()
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.category AS category_1,
          e0_.title AS title_2,
          e0_.main_image AS main_image_3,
          e0_.thumbnail AS thumbnail_4,
          e0_.summary_title AS summary_title_5,
          e0_.summary_content AS summary_content_6,
          e0_.pickup_content_description AS pickup_content_description_7,
          e0_.title_en AS title_en_8,
          e0_.title_cn AS title_cn_9,
          e0_.summary_title_en AS summary_title_en_10,
          e0_.summary_title_cn AS summary_title_cn_11,
          e0_.summary_content_en AS summary_content_en_12,
          e0_.summary_content_cn AS summary_content_cn_13,
          e0_.pickup_contents_description_en AS pickup_contents_description_en_14,
          e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15,
          e0_.title_tw AS title_tw_16,
          e0_.summary_title_tw AS summary_title_tw_17,
          e0_.summary_content_tw AS summary_content_tw_18,
          e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19,
          e0_.add_life_experience AS add_life_experience_20,
          e0_.life_experience_thumbnail AS life_experience_thumbnail_21,
          e0_.is_draft AS is_draft_22,
          e0_.approval AS approval_23,
          e0_.created_at AS created_at_24,
          e0_.updated_at AS updated_at_25,
          e0_.deleted_at AS deleted_at_26,
          a1_.id AS id_27,
          a1_.status AS status_28,
          m2_.id AS id_29
        FROM
          entry_entry e0_
          LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id)
          AND (a1_.deleted_at IS NULL)
          LEFT JOIN mst_area m2_ ON (e0_.area_id = m2_.id)
          AND (m2_.deleted_at IS NULL)
          LEFT JOIN entry_modelplan e3_ ON (e0_.id = e3_.entry_id)
          AND (e3_.deleted_at IS NULL)
        WHERE
          (
            e0_.category = ?
            AND e0_.approval = ?
            AND e0_.is_draft = ?
            AND a1_.status = ?
            AND e0_.category = ?
          )
          AND (e0_.deleted_at IS NULL)
      ) dctrn_result_inner
    ORDER BY
      RAND() ASC
  ) dctrn_result
LIMIT
  9999 OFFSET 1829817

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, RAND() FROM (SELECT e0_.id AS id_0, e0_.category AS category_1, e0_.title AS title_2, e0_.main_image AS main_image_3, e0_.thumbnail AS thumbnail_4, e0_.summary_title AS summary_title_5, e0_.summary_content AS summary_content_6, e0_.pickup_content_description AS pickup_content_description_7, e0_.title_en AS title_en_8, e0_.title_cn AS title_cn_9, e0_.summary_title_en AS summary_title_en_10, e0_.summary_title_cn AS summary_title_cn_11, e0_.summary_content_en AS summary_content_en_12, e0_.summary_content_cn AS summary_content_cn_13, e0_.pickup_contents_description_en AS pickup_contents_description_en_14, e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15, e0_.title_tw AS title_tw_16, e0_.summary_title_tw AS summary_title_tw_17, e0_.summary_content_tw AS summary_content_tw_18, e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19, e0_.add_life_experience AS add_life_experience_20, e0_.life_experience_thumbnail AS life_experience_thumbnail_21, e0_.is_draft AS is_draft_22, e0_.approval AS approval_23, e0_.created_at AS created_at_24, e0_.updated_at AS updated_at_25, e0_.deleted_at AS deleted_at_26, a1_.id AS id_27, a1_.status AS status_28, m2_.id AS id_29 FROM entry_entry e0_ LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id) AND (a1_.deleted_at IS NULL) LEFT JOIN mst_area m2_ ON (e0_.area_id = m2_.id) AND (m2_.deleted_at IS NULL) LEFT JOIN entry_modelplan e3_ ON (e0_.id = e3_.entry_id) AND (e3_.deleted_at IS NULL) WHERE (e0_.category = 1 AND e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1 AND e0_.category = 1) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY RAND() ASC) dctrn_result LIMIT 9999 OFFSET 1829817;

SELECT
  m0_.icon AS icon_0,
  m0_.created_at AS created_at_1,
  m0_.updated_at AS updated_at_2,
  m0_.deleted_at AS deleted_at_3,
  m0_.id AS id_4,
  m0_.name AS name_5,
  m0_.name_en AS name_en_6,
  m0_.name_cn AS name_cn_7,
  m0_.name_tw AS name_tw_8,
  m0_.enable AS enable_9,
  m0_.sort AS sort_10,
  m0_.is_model_plan AS is_model_plan_11,
  m0_.is_hotel AS is_hotel_12,
  m0_.is_workspace AS is_workspace_13,
  m0_.is_activity AS is_activity_14
FROM
  mst_equipment m0_
WHERE
  (
    m0_.enable = ?
    AND m0_.is_model_plan = 1
  )
  AND (m0_.deleted_at IS NULL)
ORDER BY
  m0_.sort ASC

SELECT m0_.icon AS icon_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.deleted_at AS deleted_at_3, m0_.id AS id_4, m0_.name AS name_5, m0_.name_en AS name_en_6, m0_.name_cn AS name_cn_7, m0_.name_tw AS name_tw_8, m0_.enable AS enable_9, m0_.sort AS sort_10, m0_.is_model_plan AS is_model_plan_11, m0_.is_hotel AS is_hotel_12, m0_.is_workspace AS is_workspace_13, m0_.is_activity AS is_activity_14 FROM mst_equipment m0_ WHERE (m0_.enable = 1 AND m0_.is_model_plan = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC;

SELECT
  m0_.created_at AS created_at_0,
  m0_.updated_at AS updated_at_1,
  m0_.deleted_at AS deleted_at_2,
  m0_.id AS id_3,
  m0_.name AS name_4,
  m0_.name_en AS name_en_5,
  m0_.name_cn AS name_cn_6,
  m0_.name_tw AS name_tw_7,
  m0_.enable AS enable_8,
  m0_.sort AS sort_9,
  m0_.is_model_plan AS is_model_plan_10,
  m0_.is_hotel AS is_hotel_11,
  m0_.is_workspace AS is_workspace_12,
  m0_.is_activity AS is_activity_13
FROM
  mst_service m0_
WHERE
  (
    m0_.enable = ?
    AND m0_.is_model_plan = 1
  )
  AND (m0_.deleted_at IS NULL)
ORDER BY
  m0_.sort ASC

SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.deleted_at AS deleted_at_2, m0_.id AS id_3, m0_.name AS name_4, m0_.name_en AS name_en_5, m0_.name_cn AS name_cn_6, m0_.name_tw AS name_tw_7, m0_.enable AS enable_8, m0_.sort AS sort_9, m0_.is_model_plan AS is_model_plan_10, m0_.is_hotel AS is_hotel_11, m0_.is_workspace AS is_workspace_12, m0_.is_activity AS is_activity_13 FROM mst_service m0_ WHERE (m0_.enable = 1 AND m0_.is_model_plan = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC;

SELECT
  m0_.category AS category_0,
  m0_.created_at AS created_at_1,
  m0_.updated_at AS updated_at_2,
  m0_.deleted_at AS deleted_at_3,
  m0_.id AS id_4,
  m0_.name AS name_5,
  m0_.name_en AS name_en_6,
  m0_.name_cn AS name_cn_7,
  m0_.name_tw AS name_tw_8,
  m0_.enable AS enable_9,
  m0_.sort AS sort_10,
  m0_.is_model_plan AS is_model_plan_11,
  m0_.is_hotel AS is_hotel_12,
  m0_.is_workspace AS is_workspace_13,
  m0_.is_activity AS is_activity_14
FROM
  mst_tag m0_
WHERE
  (
    m0_.enable = ?
    AND m0_.is_model_plan = 1
  )
  AND (m0_.deleted_at IS NULL)
ORDER BY
  m0_.category ASC,
  m0_.sort ASC

SELECT m0_.category AS category_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.deleted_at AS deleted_at_3, m0_.id AS id_4, m0_.name AS name_5, m0_.name_en AS name_en_6, m0_.name_cn AS name_cn_7, m0_.name_tw AS name_tw_8, m0_.enable AS enable_9, m0_.sort AS sort_10, m0_.is_model_plan AS is_model_plan_11, m0_.is_hotel AS is_hotel_12, m0_.is_workspace AS is_workspace_13, m0_.is_activity AS is_activity_14 FROM mst_tag m0_ WHERE (m0_.enable = 1 AND m0_.is_model_plan = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.category ASC, m0_.sort ASC;

SELECT
  m0_.created_at AS created_at_0,
  m0_.updated_at AS updated_at_1,
  m0_.deleted_at AS deleted_at_2,
  m0_.id AS id_3,
  m0_.name AS name_4,
  m0_.name_en AS name_en_5,
  m0_.name_cn AS name_cn_6,
  m0_.name_tw AS name_tw_7,
  m0_.enable AS enable_8,
  m0_.sort AS sort_9,
  m0_.is_model_plan AS is_model_plan_10,
  m0_.is_hotel AS is_hotel_11,
  m0_.is_workspace AS is_workspace_12,
  m0_.is_activity AS is_activity_13
FROM
  mst_target m0_
WHERE
  (
    m0_.enable = ?
    AND m0_.is_model_plan = 1
  )
  AND (m0_.deleted_at IS NULL)
ORDER BY
  m0_.sort ASC

SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.deleted_at AS deleted_at_2, m0_.id AS id_3, m0_.name AS name_4, m0_.name_en AS name_en_5, m0_.name_cn AS name_cn_6, m0_.name_tw AS name_tw_7, m0_.enable AS enable_8, m0_.sort AS sort_9, m0_.is_model_plan AS is_model_plan_10, m0_.is_hotel AS is_hotel_11, m0_.is_workspace AS is_workspace_12, m0_.is_activity AS is_activity_13 FROM mst_target m0_ WHERE (m0_.enable = 1 AND m0_.is_model_plan = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC;