Symfony Profiler

SELECT 
  p0_.id AS id_0, 
  p0_.value AS value_1, 
  p0_.num_value AS num_value_2, 
  p0_.date_value AS date_value_3, 
  p0_.sort_no AS sort_no_4, 
  p0_.discriminator_type AS discriminator_type_5, 
  p0_.product_data_id AS product_data_id_6 
FROM 
  plg_productplus_dtb_product_data_detail p0_ 
WHERE 
  (p0_.value = ?) 
  AND p0_.discriminator_type IN ('productdatadetail')

SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = '500-12-00157') AND p0_.discriminator_type IN ('productdatadetail');

SELECT 
  p0_.id AS id_0, 
  p0_.create_date AS create_date_1, 
  p0_.discriminator_type AS discriminator_type_2, 
  p0_.product_item_id AS product_item_id_3, 
  p0_.product_id AS product_id_4 
FROM 
  plg_productplus_dtb_product_data p0_ 
WHERE 
  (
    p0_.product_item_id = ? 
    AND p0_.product_id = ?
  ) 
  AND p0_.discriminator_type IN ('productdata')

SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = 1 AND p0_.product_id = 6445) AND p0_.discriminator_type IN ('productdata');

SELECT 
  count(DISTINCT d0_.id) AS sclr_0 
FROM 
  dtb_product d0_ 
  LEFT JOIN plg_schedule_time p1_ ON d0_.schedule_time_id = p1_.schedule_time_id 
  INNER JOIN dtb_product_class d2_ ON d0_.id = d2_.product_id 
  AND d2_.discriminator_type IN ('productclass') 
WHERE 
  (
    d0_.product_status_id = 1 
    AND d0_.priority_flag = 1 
    AND d0_.id NOT IN (
      SELECT 
        DISTINCT (d3_.id) 
      FROM 
        dtb_product d3_ 
        INNER JOIN plg_customer_group_products_groups p5_ ON d3_.id = p5_.product_id 
        INNER JOIN plg_customer_group p4_ ON p4_.id = p5_.group_id 
        AND p4_.discriminator_type IN ('group') 
      WHERE 
        d3_.discriminator_type IN ('product')
    ) 
    AND (
      (
        p1_.schedule_type IS NULL 
        OR p1_.schedule_type = ? 
        AND (
          (
            p1_.time_from <= ? 
            AND p1_.time_to > ?
          ) 
          OR (
            p1_.time_from <= ? 
            AND p1_.time_to IS NULL
          ) 
          OR (
            p1_.time_from IS NULL 
            AND p1_.time_to > ?
          ) 
          OR (
            p1_.time_from IS NULL 
            AND p1_.time_to IS NULL
          ) 
          OR (p1_.view_flg = 1)
        )
      ) 
      OR (
        p1_.schedule_type IS NULL 
        OR p1_.schedule_type = ? 
        AND (
          (
            p1_.time_only_from <= ? 
            AND p1_.time_only_to > ?
          ) 
          OR (
            p1_.time_only_from <= ? 
            AND p1_.time_only_to IS NULL
          ) 
          OR (
            p1_.time_only_from IS NULL 
            AND p1_.time_only_to > ?
          ) 
          OR (
            p1_.time_only_from IS NULL 
            AND p1_.time_only_to IS NULL
          ) 
          OR (p1_.view_flg = 1)
        )
      )
    ) 
    AND (
      d0_.id NOT IN (
        SELECT 
          d6_.id 
        FROM 
          dtb_product_category d7_ 
          INNER JOIN dtb_product d6_ ON d7_.product_id = d6_.id 
          AND d6_.discriminator_type IN ('product') 
          INNER JOIN dtb_category d8_ ON d7_.category_id = d8_.id 
          AND d8_.discriminator_type IN ('category') 
          INNER JOIN plg_schedule_time p9_ ON d8_.schedule_time_id = p9_.schedule_time_id 
        WHERE 
          (
            d6_.schedule_time_id IS NULL 
            AND (
              p9_.time_from > ? 
              OR p9_.time_to < ?
            )
          ) 
          AND d7_.discriminator_type IN ('productcategory')
      )
    ) 
    AND d2_.visible = 1
  ) 
  AND d0_.discriminator_type IN ('product')

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ LEFT JOIN plg_schedule_time p1_ ON d0_.schedule_time_id = p1_.schedule_time_id INNER JOIN dtb_product_class d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d0_.priority_flag = 1 AND d0_.id NOT IN (SELECT DISTINCT (d3_.id) FROM dtb_product d3_ INNER JOIN plg_customer_group_products_groups p5_ ON d3_.id = p5_.product_id INNER JOIN plg_customer_group p4_ ON p4_.id = p5_.group_id AND p4_.discriminator_type IN ('group') WHERE d3_.discriminator_type IN ('product')) AND ((p1_.schedule_type IS NULL OR p1_.schedule_type = 1 AND ((p1_.time_from <= '2024-10-05 14:32:00' AND p1_.time_to > '2024-10-05 14:32:00') OR (p1_.time_from <= '2024-10-05 14:32:00' AND p1_.time_to IS NULL) OR (p1_.time_from IS NULL AND p1_.time_to > '2024-10-05 14:32:00') OR (p1_.time_from IS NULL AND p1_.time_to IS NULL) OR (p1_.view_flg = 1))) OR (p1_.schedule_type IS NULL OR p1_.schedule_type = 6 AND ((p1_.time_only_from <= '2332' AND p1_.time_only_to > '2332') OR (p1_.time_only_from <= '2332' AND p1_.time_only_to IS NULL) OR (p1_.time_only_from IS NULL AND p1_.time_only_to > '2332') OR (p1_.time_only_from IS NULL AND p1_.time_only_to IS NULL) OR (p1_.view_flg = 1)))) AND (d0_.id NOT IN (SELECT d6_.id FROM dtb_product_category d7_ INNER JOIN dtb_product d6_ ON d7_.product_id = d6_.id AND d6_.discriminator_type IN ('product') INNER JOIN dtb_category d8_ ON d7_.category_id = d8_.id AND d8_.discriminator_type IN ('category') INNER JOIN plg_schedule_time p9_ ON d8_.schedule_time_id = p9_.schedule_time_id WHERE (d6_.schedule_time_id IS NULL AND (p9_.time_from > '2024-10-05 14:32:00' OR p9_.time_to < '2024-10-05 14:32:00')) AND d7_.discriminator_type IN ('productcategory'))) AND d2_.visible = 1) AND d0_.discriminator_type IN ('product');

SELECT 
  DISTINCT d0_.id AS id_0, 
  d0_.create_date AS create_date_1, 
  d0_.id AS id_2 
FROM 
  dtb_product d0_ 
  LEFT JOIN plg_schedule_time p1_ ON d0_.schedule_time_id = p1_.schedule_time_id 
  INNER JOIN dtb_product_class d2_ ON d0_.id = d2_.product_id 
  AND d2_.discriminator_type IN ('productclass') 
WHERE 
  (
    d0_.product_status_id = 1 
    AND d0_.priority_flag = 1 
    AND d0_.id NOT IN (
      SELECT 
        DISTINCT (d3_.id) 
      FROM 
        dtb_product d3_ 
        INNER JOIN plg_customer_group_products_groups p5_ ON d3_.id = p5_.product_id 
        INNER JOIN plg_customer_group p4_ ON p4_.id = p5_.group_id 
        AND p4_.discriminator_type IN ('group') 
      WHERE 
        d3_.discriminator_type IN ('product')
    ) 
    AND (
      (
        p1_.schedule_type IS NULL 
        OR p1_.schedule_type = ? 
        AND (
          (
            p1_.time_from <= ? 
            AND p1_.time_to > ?
          ) 
          OR (
            p1_.time_from <= ? 
            AND p1_.time_to IS NULL
          ) 
          OR (
            p1_.time_from IS NULL 
            AND p1_.time_to > ?
          ) 
          OR (
            p1_.time_from IS NULL 
            AND p1_.time_to IS NULL
          ) 
          OR (p1_.view_flg = 1)
        )
      ) 
      OR (
        p1_.schedule_type IS NULL 
        OR p1_.schedule_type = ? 
        AND (
          (
            p1_.time_only_from <= ? 
            AND p1_.time_only_to > ?
          ) 
          OR (
            p1_.time_only_from <= ? 
            AND p1_.time_only_to IS NULL
          ) 
          OR (
            p1_.time_only_from IS NULL 
            AND p1_.time_only_to > ?
          ) 
          OR (
            p1_.time_only_from IS NULL 
            AND p1_.time_only_to IS NULL
          ) 
          OR (p1_.view_flg = 1)
        )
      )
    ) 
    AND (
      d0_.id NOT IN (
        SELECT 
          d6_.id 
        FROM 
          dtb_product_category d7_ 
          INNER JOIN dtb_product d6_ ON d7_.product_id = d6_.id 
          AND d6_.discriminator_type IN ('product') 
          INNER JOIN dtb_category d8_ ON d7_.category_id = d8_.id 
          AND d8_.discriminator_type IN ('category') 
          INNER JOIN plg_schedule_time p9_ ON d8_.schedule_time_id = p9_.schedule_time_id 
        WHERE 
          (
            d6_.schedule_time_id IS NULL 
            AND (
              p9_.time_from > ? 
              OR p9_.time_to < ?
            )
          ) 
          AND d7_.discriminator_type IN ('productcategory')
      )
    ) 
    AND d2_.visible = 1
  ) 
  AND d0_.discriminator_type IN ('product') 
ORDER BY 
  d0_.create_date DESC, 
  d0_.id DESC 
LIMIT 
  20 OFFSET 1360

SELECT DISTINCT d0_.id AS id_0, d0_.create_date AS create_date_1, d0_.id AS id_2 FROM dtb_product d0_ LEFT JOIN plg_schedule_time p1_ ON d0_.schedule_time_id = p1_.schedule_time_id INNER JOIN dtb_product_class d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d0_.priority_flag = 1 AND d0_.id NOT IN (SELECT DISTINCT (d3_.id) FROM dtb_product d3_ INNER JOIN plg_customer_group_products_groups p5_ ON d3_.id = p5_.product_id INNER JOIN plg_customer_group p4_ ON p4_.id = p5_.group_id AND p4_.discriminator_type IN ('group') WHERE d3_.discriminator_type IN ('product')) AND ((p1_.schedule_type IS NULL OR p1_.schedule_type = 1 AND ((p1_.time_from <= '2024-10-05 14:32:00' AND p1_.time_to > '2024-10-05 14:32:00') OR (p1_.time_from <= '2024-10-05 14:32:00' AND p1_.time_to IS NULL) OR (p1_.time_from IS NULL AND p1_.time_to > '2024-10-05 14:32:00') OR (p1_.time_from IS NULL AND p1_.time_to IS NULL) OR (p1_.view_flg = 1))) OR (p1_.schedule_type IS NULL OR p1_.schedule_type = 6 AND ((p1_.time_only_from <= '2332' AND p1_.time_only_to > '2332') OR (p1_.time_only_from <= '2332' AND p1_.time_only_to IS NULL) OR (p1_.time_only_from IS NULL AND p1_.time_only_to > '2332') OR (p1_.time_only_from IS NULL AND p1_.time_only_to IS NULL) OR (p1_.view_flg = 1)))) AND (d0_.id NOT IN (SELECT d6_.id FROM dtb_product_category d7_ INNER JOIN dtb_product d6_ ON d7_.product_id = d6_.id AND d6_.discriminator_type IN ('product') INNER JOIN dtb_category d8_ ON d7_.category_id = d8_.id AND d8_.discriminator_type IN ('category') INNER JOIN plg_schedule_time p9_ ON d8_.schedule_time_id = p9_.schedule_time_id WHERE (d6_.schedule_time_id IS NULL AND (p9_.time_from > '2024-10-05 14:32:00' OR p9_.time_to < '2024-10-05 14:32:00')) AND d7_.discriminator_type IN ('productcategory'))) AND d2_.visible = 1) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC LIMIT 20 OFFSET 1360;

SELECT 
  t0.id AS id_1, 
  t0.create_date AS create_date_2, 
  t0.product_item_id AS product_item_id_3, 
  t0.product_id AS product_id_4, 
  t0.discriminator_type 
FROM 
  plg_productplus_dtb_product_data t0 
WHERE 
  t0.id = ? 
  AND t0.discriminator_type IN ('productdata')

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = 84321 AND t0.discriminator_type IN ('productdata');

SELECT 
  t0.product_id AS product_id_1, 
  t0.category_id AS category_id_2, 
  t0.product_id AS product_id_3, 
  t0.category_id AS category_id_4, 
  t0.discriminator_type 
FROM 
  dtb_product_category t0 
WHERE 
  t0.product_id = ? 
  AND t0.discriminator_type IN ('productcategory') 
  AND (
    (
      (
        t0.category_id in (
          select 
            id 
          from 
            dtb_category 
          where 
            schedule_time_id in (
              select 
                schedule_time_id 
              from 
                plg_schedule_time 
              where 
                (
                  (
                    time_from < '2024-10-05 14:32:01' 
                    and time_to > '2024-10-05 14:32:01'
                  ) 
                  or (
                    time_from < '2024-10-05 14:32:01' 
                    and time_to is null
                  ) 
                  or (
                    time_from is null 
                    and time_to > '2024-10-05 14:32:01'
                  ) 
                  or (
                    time_from is null 
                    and time_to is null
                  )
                ) 
                and (
                  chain_schedule_time_id not in (
                    select 
                      schedule_time_id 
                    from 
                      plg_schedule_time 
                    where 
                      time_from > '2024-10-05 14:32:01' 
                      or time_to < '2024-10-05 14:32:01'
                  ) 
                  or chain_schedule_time_id is null
                )
            ) 
            or schedule_time_id is null
        )
      )
    )
  )

SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = 6445 AND t0.discriminator_type IN ('productcategory') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:01' and time_to > '2024-10-05 14:32:01')
          or (time_from < '2024-10-05 14:32:01' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:01')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:01' or time_to < '2024-10-05 14:32:01'
          ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))));

SELECT 
  p0_.id AS id_0, 
  p0_.value AS value_1, 
  p0_.num_value AS num_value_2, 
  p0_.date_value AS date_value_3, 
  p0_.sort_no AS sort_no_4, 
  p0_.discriminator_type AS discriminator_type_5, 
  p0_.product_data_id AS product_data_id_6 
FROM 
  plg_productplus_dtb_product_data_detail p0_ 
WHERE 
  (p0_.product_data_id = ?) 
  AND p0_.discriminator_type IN ('productdatadetail')

SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = 84316) AND p0_.discriminator_type IN ('productdatadetail');

SELECT 
  d0_.id AS id_0, 
  d0_.category_name AS category_name_1, 
  d0_.hierarchy AS hierarchy_2, 
  d0_.sort_no AS sort_no_3, 
  d0_.create_date AS create_date_4, 
  d0_.update_date AS update_date_5, 
  d0_.plg_content AS plg_content_6, 
  d0_.plg_meta_description AS plg_meta_description_7, 
  d0_.plg_file_name AS plg_file_name_8, 
  d0_.plg_slug AS plg_slug_9, 
  d1_.id AS id_10, 
  d1_.category_name AS category_name_11, 
  d1_.hierarchy AS hierarchy_12, 
  d1_.sort_no AS sort_no_13, 
  d1_.create_date AS create_date_14, 
  d1_.update_date AS update_date_15, 
  d1_.plg_content AS plg_content_16, 
  d1_.plg_meta_description AS plg_meta_description_17, 
  d1_.plg_file_name AS plg_file_name_18, 
  d1_.plg_slug AS plg_slug_19, 
  d2_.id AS id_20, 
  d2_.category_name AS category_name_21, 
  d2_.hierarchy AS hierarchy_22, 
  d2_.sort_no AS sort_no_23, 
  d2_.create_date AS create_date_24, 
  d2_.update_date AS update_date_25, 
  d2_.plg_content AS plg_content_26, 
  d2_.plg_meta_description AS plg_meta_description_27, 
  d2_.plg_file_name AS plg_file_name_28, 
  d2_.plg_slug AS plg_slug_29, 
  d3_.id AS id_30, 
  d3_.category_name AS category_name_31, 
  d3_.hierarchy AS hierarchy_32, 
  d3_.sort_no AS sort_no_33, 
  d3_.create_date AS create_date_34, 
  d3_.update_date AS update_date_35, 
  d3_.plg_content AS plg_content_36, 
  d3_.plg_meta_description AS plg_meta_description_37, 
  d3_.plg_file_name AS plg_file_name_38, 
  d3_.plg_slug AS plg_slug_39, 
  d4_.id AS id_40, 
  d4_.category_name AS category_name_41, 
  d4_.hierarchy AS hierarchy_42, 
  d4_.sort_no AS sort_no_43, 
  d4_.create_date AS create_date_44, 
  d4_.update_date AS update_date_45, 
  d4_.plg_content AS plg_content_46, 
  d4_.plg_meta_description AS plg_meta_description_47, 
  d4_.plg_file_name AS plg_file_name_48, 
  d4_.plg_slug AS plg_slug_49, 
  d0_.discriminator_type AS discriminator_type_50, 
  d0_.parent_category_id AS parent_category_id_51, 
  d0_.creator_id AS creator_id_52, 
  d0_.schedule_time_id AS schedule_time_id_53, 
  d1_.discriminator_type AS discriminator_type_54, 
  d1_.parent_category_id AS parent_category_id_55, 
  d1_.creator_id AS creator_id_56, 
  d1_.schedule_time_id AS schedule_time_id_57, 
  d2_.discriminator_type AS discriminator_type_58, 
  d2_.parent_category_id AS parent_category_id_59, 
  d2_.creator_id AS creator_id_60, 
  d2_.schedule_time_id AS schedule_time_id_61, 
  d3_.discriminator_type AS discriminator_type_62, 
  d3_.parent_category_id AS parent_category_id_63, 
  d3_.creator_id AS creator_id_64, 
  d3_.schedule_time_id AS schedule_time_id_65, 
  d4_.discriminator_type AS discriminator_type_66, 
  d4_.parent_category_id AS parent_category_id_67, 
  d4_.creator_id AS creator_id_68, 
  d4_.schedule_time_id AS schedule_time_id_69 
FROM 
  dtb_category d0_ 
  LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id 
  AND d1_.discriminator_type IN ('category') 
  AND (
    (
      d1_.schedule_time_id is null 
      or (
        d1_.schedule_time_id in (
          select 
            schedule_time_id 
          from 
            plg_schedule_time 
          where 
            (
              (
                time_from < '2024-10-05 14:32:00' 
                and time_to > '2024-10-05 14:32:00'
              ) 
              or (
                time_from < '2024-10-05 14:32:00' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-10-05 14:32:00'
              ) 
              or (
                time_from is null 
                and time_to is null
              )
            ) 
            and (
              chain_schedule_time_id not in (
                select 
                  schedule_time_id 
                from 
                  plg_schedule_time 
                where 
                  time_from > '2024-10-05 14:32:00' 
                  or time_to < '2024-10-05 14:32:00'
              ) 
              or chain_schedule_time_id is null
            )
        )
      )
    )
  ) 
  LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id 
  AND d2_.discriminator_type IN ('category') 
  AND (
    (
      d2_.schedule_time_id is null 
      or (
        d2_.schedule_time_id in (
          select 
            schedule_time_id 
          from 
            plg_schedule_time 
          where 
            (
              (
                time_from < '2024-10-05 14:32:00' 
                and time_to > '2024-10-05 14:32:00'
              ) 
              or (
                time_from < '2024-10-05 14:32:00' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-10-05 14:32:00'
              ) 
              or (
                time_from is null 
                and time_to is null
              )
            ) 
            and (
              chain_schedule_time_id not in (
                select 
                  schedule_time_id 
                from 
                  plg_schedule_time 
                where 
                  time_from > '2024-10-05 14:32:00' 
                  or time_to < '2024-10-05 14:32:00'
              ) 
              or chain_schedule_time_id is null
            )
        )
      )
    )
  ) 
  LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id 
  AND d3_.discriminator_type IN ('category') 
  AND (
    (
      d3_.schedule_time_id is null 
      or (
        d3_.schedule_time_id in (
          select 
            schedule_time_id 
          from 
            plg_schedule_time 
          where 
            (
              (
                time_from < '2024-10-05 14:32:00' 
                and time_to > '2024-10-05 14:32:00'
              ) 
              or (
                time_from < '2024-10-05 14:32:00' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-10-05 14:32:00'
              ) 
              or (
                time_from is null 
                and time_to is null
              )
            ) 
            and (
              chain_schedule_time_id not in (
                select 
                  schedule_time_id 
                from 
                  plg_schedule_time 
                where 
                  time_from > '2024-10-05 14:32:00' 
                  or time_to < '2024-10-05 14:32:00'
              ) 
              or chain_schedule_time_id is null
            )
        )
      )
    )
  ) 
  LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id 
  AND d4_.discriminator_type IN ('category') 
  AND (
    (
      d4_.schedule_time_id is null 
      or (
        d4_.schedule_time_id in (
          select 
            schedule_time_id 
          from 
            plg_schedule_time 
          where 
            (
              (
                time_from < '2024-10-05 14:32:00' 
                and time_to > '2024-10-05 14:32:00'
              ) 
              or (
                time_from < '2024-10-05 14:32:00' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-10-05 14:32:00'
              ) 
              or (
                time_from is null 
                and time_to is null
              )
            ) 
            and (
              chain_schedule_time_id not in (
                select 
                  schedule_time_id 
                from 
                  plg_schedule_time 
                where 
                  time_from > '2024-10-05 14:32:00' 
                  or time_to < '2024-10-05 14:32:00'
              ) 
              or chain_schedule_time_id is null
            )
        )
      )
    )
  ) 
WHERE 
  (
    (d0_.parent_category_id IS NULL) 
    AND (
      (
        d0_.schedule_time_id is null 
        or (
          d0_.schedule_time_id in (
            select 
              schedule_time_id 
            from 
              plg_schedule_time 
            where 
              (
                (
                  time_from < '2024-10-05 14:32:00' 
                  and time_to > '2024-10-05 14:32:00'
                ) 
                or (
                  time_from < '2024-10-05 14:32:00' 
                  and time_to is null
                ) 
                or (
                  time_from is null 
                  and time_to > '2024-10-05 14:32:00'
                ) 
                or (
                  time_from is null 
                  and time_to is null
                )
              ) 
              and (
                chain_schedule_time_id not in (
                  select 
                    schedule_time_id 
                  from 
                    plg_schedule_time 
                  where 
                    time_from > '2024-10-05 14:32:00' 
                    or time_to < '2024-10-05 14:32:00'
                ) 
                or chain_schedule_time_id is null
              )
          )
        )
      )
    )
  ) 
  AND d0_.discriminator_type IN ('category') 
ORDER BY 
  d0_.sort_no DESC, 
  d1_.sort_no ASC, 
  d2_.sort_no ASC, 
  d3_.sort_no ASC, 
  d4_.sort_no ASC

SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.plg_content AS plg_content_6, d0_.plg_meta_description AS plg_meta_description_7, d0_.plg_file_name AS plg_file_name_8, d0_.plg_slug AS plg_slug_9, d1_.id AS id_10, d1_.category_name AS category_name_11, d1_.hierarchy AS hierarchy_12, d1_.sort_no AS sort_no_13, d1_.create_date AS create_date_14, d1_.update_date AS update_date_15, d1_.plg_content AS plg_content_16, d1_.plg_meta_description AS plg_meta_description_17, d1_.plg_file_name AS plg_file_name_18, d1_.plg_slug AS plg_slug_19, d2_.id AS id_20, d2_.category_name AS category_name_21, d2_.hierarchy AS hierarchy_22, d2_.sort_no AS sort_no_23, d2_.create_date AS create_date_24, d2_.update_date AS update_date_25, d2_.plg_content AS plg_content_26, d2_.plg_meta_description AS plg_meta_description_27, d2_.plg_file_name AS plg_file_name_28, d2_.plg_slug AS plg_slug_29, d3_.id AS id_30, d3_.category_name AS category_name_31, d3_.hierarchy AS hierarchy_32, d3_.sort_no AS sort_no_33, d3_.create_date AS create_date_34, d3_.update_date AS update_date_35, d3_.plg_content AS plg_content_36, d3_.plg_meta_description AS plg_meta_description_37, d3_.plg_file_name AS plg_file_name_38, d3_.plg_slug AS plg_slug_39, d4_.id AS id_40, d4_.category_name AS category_name_41, d4_.hierarchy AS hierarchy_42, d4_.sort_no AS sort_no_43, d4_.create_date AS create_date_44, d4_.update_date AS update_date_45, d4_.plg_content AS plg_content_46, d4_.plg_meta_description AS plg_meta_description_47, d4_.plg_file_name AS plg_file_name_48, d4_.plg_slug AS plg_slug_49, d0_.discriminator_type AS discriminator_type_50, d0_.parent_category_id AS parent_category_id_51, d0_.creator_id AS creator_id_52, d0_.schedule_time_id AS schedule_time_id_53, d1_.discriminator_type AS discriminator_type_54, d1_.parent_category_id AS parent_category_id_55, d1_.creator_id AS creator_id_56, d1_.schedule_time_id AS schedule_time_id_57, d2_.discriminator_type AS discriminator_type_58, d2_.parent_category_id AS parent_category_id_59, d2_.creator_id AS creator_id_60, d2_.schedule_time_id AS schedule_time_id_61, d3_.discriminator_type AS discriminator_type_62, d3_.parent_category_id AS parent_category_id_63, d3_.creator_id AS creator_id_64, d3_.schedule_time_id AS schedule_time_id_65, d4_.discriminator_type AS discriminator_type_66, d4_.parent_category_id AS parent_category_id_67, d4_.creator_id AS creator_id_68, d4_.schedule_time_id AS schedule_time_id_69 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') AND ((d1_.schedule_time_id is null or (d1_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:00' and time_to > '2024-10-05 14:32:00')
          or (time_from < '2024-10-05 14:32:00' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:00')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:00' or time_to < '2024-10-05 14:32:00'
          ) or chain_schedule_time_id is null)  ) ))) LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') AND ((d2_.schedule_time_id is null or (d2_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:00' and time_to > '2024-10-05 14:32:00')
          or (time_from < '2024-10-05 14:32:00' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:00')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:00' or time_to < '2024-10-05 14:32:00'
          ) or chain_schedule_time_id is null)  ) ))) LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') AND ((d3_.schedule_time_id is null or (d3_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:00' and time_to > '2024-10-05 14:32:00')
          or (time_from < '2024-10-05 14:32:00' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:00')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:00' or time_to < '2024-10-05 14:32:00'
          ) or chain_schedule_time_id is null)  ) ))) LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') AND ((d4_.schedule_time_id is null or (d4_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:00' and time_to > '2024-10-05 14:32:00')
          or (time_from < '2024-10-05 14:32:00' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:00')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:00' or time_to < '2024-10-05 14:32:00'
          ) or chain_schedule_time_id is null)  ) ))) WHERE ((d0_.parent_category_id IS NULL) AND ((d0_.schedule_time_id is null or (d0_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:00' and time_to > '2024-10-05 14:32:00')
          or (time_from < '2024-10-05 14:32:00' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:00')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:00' or time_to < '2024-10-05 14:32:00'
          ) or chain_schedule_time_id is null)  ) )))) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no ASC, d2_.sort_no ASC, d3_.sort_no ASC, d4_.sort_no ASC;

SELECT 
  p0_.id AS id_0, 
  p0_.create_date AS create_date_1, 
  p0_.discriminator_type AS discriminator_type_2, 
  p0_.product_item_id AS product_item_id_3, 
  p0_.product_id AS product_id_4 
FROM 
  plg_productplus_dtb_product_data p0_ 
WHERE 
  (p0_.id = 83416) 
  AND p0_.discriminator_type IN ('productdata')

SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 83416) AND p0_.discriminator_type IN ('productdata');

SELECT 
  d0_.id AS id_0, 
  d0_.category_name AS category_name_1, 
  d0_.hierarchy AS hierarchy_2, 
  d0_.sort_no AS sort_no_3, 
  d0_.create_date AS create_date_4, 
  d0_.update_date AS update_date_5, 
  d0_.plg_content AS plg_content_6, 
  d0_.plg_meta_description AS plg_meta_description_7, 
  d0_.plg_file_name AS plg_file_name_8, 
  d0_.plg_slug AS plg_slug_9, 
  d1_.id AS id_10, 
  d1_.category_name AS category_name_11, 
  d1_.hierarchy AS hierarchy_12, 
  d1_.sort_no AS sort_no_13, 
  d1_.create_date AS create_date_14, 
  d1_.update_date AS update_date_15, 
  d1_.plg_content AS plg_content_16, 
  d1_.plg_meta_description AS plg_meta_description_17, 
  d1_.plg_file_name AS plg_file_name_18, 
  d1_.plg_slug AS plg_slug_19, 
  d2_.id AS id_20, 
  d2_.category_name AS category_name_21, 
  d2_.hierarchy AS hierarchy_22, 
  d2_.sort_no AS sort_no_23, 
  d2_.create_date AS create_date_24, 
  d2_.update_date AS update_date_25, 
  d2_.plg_content AS plg_content_26, 
  d2_.plg_meta_description AS plg_meta_description_27, 
  d2_.plg_file_name AS plg_file_name_28, 
  d2_.plg_slug AS plg_slug_29, 
  d3_.id AS id_30, 
  d3_.category_name AS category_name_31, 
  d3_.hierarchy AS hierarchy_32, 
  d3_.sort_no AS sort_no_33, 
  d3_.create_date AS create_date_34, 
  d3_.update_date AS update_date_35, 
  d3_.plg_content AS plg_content_36, 
  d3_.plg_meta_description AS plg_meta_description_37, 
  d3_.plg_file_name AS plg_file_name_38, 
  d3_.plg_slug AS plg_slug_39, 
  d4_.id AS id_40, 
  d4_.category_name AS category_name_41, 
  d4_.hierarchy AS hierarchy_42, 
  d4_.sort_no AS sort_no_43, 
  d4_.create_date AS create_date_44, 
  d4_.update_date AS update_date_45, 
  d4_.plg_content AS plg_content_46, 
  d4_.plg_meta_description AS plg_meta_description_47, 
  d4_.plg_file_name AS plg_file_name_48, 
  d4_.plg_slug AS plg_slug_49, 
  d0_.discriminator_type AS discriminator_type_50, 
  d0_.parent_category_id AS parent_category_id_51, 
  d0_.creator_id AS creator_id_52, 
  d0_.schedule_time_id AS schedule_time_id_53, 
  d1_.discriminator_type AS discriminator_type_54, 
  d1_.parent_category_id AS parent_category_id_55, 
  d1_.creator_id AS creator_id_56, 
  d1_.schedule_time_id AS schedule_time_id_57, 
  d2_.discriminator_type AS discriminator_type_58, 
  d2_.parent_category_id AS parent_category_id_59, 
  d2_.creator_id AS creator_id_60, 
  d2_.schedule_time_id AS schedule_time_id_61, 
  d3_.discriminator_type AS discriminator_type_62, 
  d3_.parent_category_id AS parent_category_id_63, 
  d3_.creator_id AS creator_id_64, 
  d3_.schedule_time_id AS schedule_time_id_65, 
  d4_.discriminator_type AS discriminator_type_66, 
  d4_.parent_category_id AS parent_category_id_67, 
  d4_.creator_id AS creator_id_68, 
  d4_.schedule_time_id AS schedule_time_id_69 
FROM 
  dtb_category d0_ 
  LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id 
  AND d1_.discriminator_type IN ('category') 
  AND (
    (
      d1_.schedule_time_id is null 
      or (
        d1_.schedule_time_id in (
          select 
            schedule_time_id 
          from 
            plg_schedule_time 
          where 
            (
              (
                time_from < '2024-10-05 14:32:01' 
                and time_to > '2024-10-05 14:32:01'
              ) 
              or (
                time_from < '2024-10-05 14:32:01' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-10-05 14:32:01'
              ) 
              or (
                time_from is null 
                and time_to is null
              )
            ) 
            and (
              chain_schedule_time_id not in (
                select 
                  schedule_time_id 
                from 
                  plg_schedule_time 
                where 
                  time_from > '2024-10-05 14:32:01' 
                  or time_to < '2024-10-05 14:32:01'
              ) 
              or chain_schedule_time_id is null
            )
        )
      )
    )
  ) 
  LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id 
  AND d2_.discriminator_type IN ('category') 
  AND (
    (
      d2_.schedule_time_id is null 
      or (
        d2_.schedule_time_id in (
          select 
            schedule_time_id 
          from 
            plg_schedule_time 
          where 
            (
              (
                time_from < '2024-10-05 14:32:01' 
                and time_to > '2024-10-05 14:32:01'
              ) 
              or (
                time_from < '2024-10-05 14:32:01' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-10-05 14:32:01'
              ) 
              or (
                time_from is null 
                and time_to is null
              )
            ) 
            and (
              chain_schedule_time_id not in (
                select 
                  schedule_time_id 
                from 
                  plg_schedule_time 
                where 
                  time_from > '2024-10-05 14:32:01' 
                  or time_to < '2024-10-05 14:32:01'
              ) 
              or chain_schedule_time_id is null
            )
        )
      )
    )
  ) 
  LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id 
  AND d3_.discriminator_type IN ('category') 
  AND (
    (
      d3_.schedule_time_id is null 
      or (
        d3_.schedule_time_id in (
          select 
            schedule_time_id 
          from 
            plg_schedule_time 
          where 
            (
              (
                time_from < '2024-10-05 14:32:01' 
                and time_to > '2024-10-05 14:32:01'
              ) 
              or (
                time_from < '2024-10-05 14:32:01' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-10-05 14:32:01'
              ) 
              or (
                time_from is null 
                and time_to is null
              )
            ) 
            and (
              chain_schedule_time_id not in (
                select 
                  schedule_time_id 
                from 
                  plg_schedule_time 
                where 
                  time_from > '2024-10-05 14:32:01' 
                  or time_to < '2024-10-05 14:32:01'
              ) 
              or chain_schedule_time_id is null
            )
        )
      )
    )
  ) 
  LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id 
  AND d4_.discriminator_type IN ('category') 
  AND (
    (
      d4_.schedule_time_id is null 
      or (
        d4_.schedule_time_id in (
          select 
            schedule_time_id 
          from 
            plg_schedule_time 
          where 
            (
              (
                time_from < '2024-10-05 14:32:01' 
                and time_to > '2024-10-05 14:32:01'
              ) 
              or (
                time_from < '2024-10-05 14:32:01' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-10-05 14:32:01'
              ) 
              or (
                time_from is null 
                and time_to is null
              )
            ) 
            and (
              chain_schedule_time_id not in (
                select 
                  schedule_time_id 
                from 
                  plg_schedule_time 
                where 
                  time_from > '2024-10-05 14:32:01' 
                  or time_to < '2024-10-05 14:32:01'
              ) 
              or chain_schedule_time_id is null
            )
        )
      )
    )
  ) 
WHERE 
  (
    (d0_.parent_category_id IS NULL) 
    AND (
      (
        d0_.schedule_time_id is null 
        or (
          d0_.schedule_time_id in (
            select 
              schedule_time_id 
            from 
              plg_schedule_time 
            where 
              (
                (
                  time_from < '2024-10-05 14:32:01' 
                  and time_to > '2024-10-05 14:32:01'
                ) 
                or (
                  time_from < '2024-10-05 14:32:01' 
                  and time_to is null
                ) 
                or (
                  time_from is null 
                  and time_to > '2024-10-05 14:32:01'
                ) 
                or (
                  time_from is null 
                  and time_to is null
                )
              ) 
              and (
                chain_schedule_time_id not in (
                  select 
                    schedule_time_id 
                  from 
                    plg_schedule_time 
                  where 
                    time_from > '2024-10-05 14:32:01' 
                    or time_to < '2024-10-05 14:32:01'
                ) 
                or chain_schedule_time_id is null
              )
          )
        )
      )
    )
  ) 
  AND d0_.discriminator_type IN ('category') 
ORDER BY 
  d0_.sort_no DESC, 
  d1_.sort_no ASC, 
  d2_.sort_no ASC, 
  d3_.sort_no ASC, 
  d4_.sort_no ASC

SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.plg_content AS plg_content_6, d0_.plg_meta_description AS plg_meta_description_7, d0_.plg_file_name AS plg_file_name_8, d0_.plg_slug AS plg_slug_9, d1_.id AS id_10, d1_.category_name AS category_name_11, d1_.hierarchy AS hierarchy_12, d1_.sort_no AS sort_no_13, d1_.create_date AS create_date_14, d1_.update_date AS update_date_15, d1_.plg_content AS plg_content_16, d1_.plg_meta_description AS plg_meta_description_17, d1_.plg_file_name AS plg_file_name_18, d1_.plg_slug AS plg_slug_19, d2_.id AS id_20, d2_.category_name AS category_name_21, d2_.hierarchy AS hierarchy_22, d2_.sort_no AS sort_no_23, d2_.create_date AS create_date_24, d2_.update_date AS update_date_25, d2_.plg_content AS plg_content_26, d2_.plg_meta_description AS plg_meta_description_27, d2_.plg_file_name AS plg_file_name_28, d2_.plg_slug AS plg_slug_29, d3_.id AS id_30, d3_.category_name AS category_name_31, d3_.hierarchy AS hierarchy_32, d3_.sort_no AS sort_no_33, d3_.create_date AS create_date_34, d3_.update_date AS update_date_35, d3_.plg_content AS plg_content_36, d3_.plg_meta_description AS plg_meta_description_37, d3_.plg_file_name AS plg_file_name_38, d3_.plg_slug AS plg_slug_39, d4_.id AS id_40, d4_.category_name AS category_name_41, d4_.hierarchy AS hierarchy_42, d4_.sort_no AS sort_no_43, d4_.create_date AS create_date_44, d4_.update_date AS update_date_45, d4_.plg_content AS plg_content_46, d4_.plg_meta_description AS plg_meta_description_47, d4_.plg_file_name AS plg_file_name_48, d4_.plg_slug AS plg_slug_49, d0_.discriminator_type AS discriminator_type_50, d0_.parent_category_id AS parent_category_id_51, d0_.creator_id AS creator_id_52, d0_.schedule_time_id AS schedule_time_id_53, d1_.discriminator_type AS discriminator_type_54, d1_.parent_category_id AS parent_category_id_55, d1_.creator_id AS creator_id_56, d1_.schedule_time_id AS schedule_time_id_57, d2_.discriminator_type AS discriminator_type_58, d2_.parent_category_id AS parent_category_id_59, d2_.creator_id AS creator_id_60, d2_.schedule_time_id AS schedule_time_id_61, d3_.discriminator_type AS discriminator_type_62, d3_.parent_category_id AS parent_category_id_63, d3_.creator_id AS creator_id_64, d3_.schedule_time_id AS schedule_time_id_65, d4_.discriminator_type AS discriminator_type_66, d4_.parent_category_id AS parent_category_id_67, d4_.creator_id AS creator_id_68, d4_.schedule_time_id AS schedule_time_id_69 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') AND ((d1_.schedule_time_id is null or (d1_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:01' and time_to > '2024-10-05 14:32:01')
          or (time_from < '2024-10-05 14:32:01' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:01')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:01' or time_to < '2024-10-05 14:32:01'
          ) or chain_schedule_time_id is null)  ) ))) LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') AND ((d2_.schedule_time_id is null or (d2_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:01' and time_to > '2024-10-05 14:32:01')
          or (time_from < '2024-10-05 14:32:01' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:01')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:01' or time_to < '2024-10-05 14:32:01'
          ) or chain_schedule_time_id is null)  ) ))) LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') AND ((d3_.schedule_time_id is null or (d3_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:01' and time_to > '2024-10-05 14:32:01')
          or (time_from < '2024-10-05 14:32:01' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:01')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:01' or time_to < '2024-10-05 14:32:01'
          ) or chain_schedule_time_id is null)  ) ))) LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') AND ((d4_.schedule_time_id is null or (d4_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:01' and time_to > '2024-10-05 14:32:01')
          or (time_from < '2024-10-05 14:32:01' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:01')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:01' or time_to < '2024-10-05 14:32:01'
          ) or chain_schedule_time_id is null)  ) ))) WHERE ((d0_.parent_category_id IS NULL) AND ((d0_.schedule_time_id is null or (d0_.schedule_time_id in (         select schedule_time_id from plg_schedule_time where (
          (time_from < '2024-10-05 14:32:01' and time_to > '2024-10-05 14:32:01')
          or (time_from < '2024-10-05 14:32:01' and time_to is null)
          or (time_from is null and time_to > '2024-10-05 14:32:01')
          or (time_from is null and time_to is null))
          and (chain_schedule_time_id not in (
            select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 14:32:01' or time_to < '2024-10-05 14:32:01'
          ) or chain_schedule_time_id is null)  ) )))) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no ASC, d2_.sort_no ASC, d3_.sort_no ASC, d4_.sort_no ASC;