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 = 'ikkatsu-OC012155307') 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 = 11929) AND p0_.discriminator_type IN ('productdata');

SELECT 
  d0_.id AS id_0, 
  d0_.name AS name_1, 
  d0_.note AS note_2, 
  d0_.description_list AS description_list_3, 
  d0_.description_detail AS description_detail_4, 
  d0_.search_word AS search_word_5, 
  d0_.free_area AS free_area_6, 
  d0_.create_date AS create_date_7, 
  d0_.update_date AS update_date_8, 
  d0_.slug AS slug_9, 
  d0_.grouping_code AS grouping_code_10, 
  d0_.priority_flag AS priority_flag_11, 
  d0_.shipping_name AS shipping_name_12, 
  d0_.plg_pu_private AS plg_pu_private_13, 
  d0_.plg_pu_private_key AS plg_pu_private_key_14, 
  d0_.plg_pu_publish_date AS plg_pu_publish_date_15, 
  d0_.free_description_about_quantity AS free_description_about_quantity_16, 
  d0_.free_description_about_selling_price AS free_description_about_selling_price_17, 
  d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_18, 
  d0_.discriminator_type AS discriminator_type_19, 
  d0_.creator_id AS creator_id_20, 
  d0_.product_status_id AS product_status_id_21, 
  d0_.schedule_time_id AS schedule_time_id_22 
FROM 
  dtb_product d0_ 
  LEFT JOIN dtb_product_tag d1_ ON d0_.id = d1_.product_id 
  AND d1_.discriminator_type IN ('producttag') 
WHERE 
  (
    d0_.product_status_id = 1 
    AND d0_.priority_flag = 1 
    AND d1_.tag_id = ?
  ) 
  AND d0_.discriminator_type IN ('product') 
ORDER BY 
  d0_.create_date DESC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.slug AS slug_9, d0_.grouping_code AS grouping_code_10, d0_.priority_flag AS priority_flag_11, d0_.shipping_name AS shipping_name_12, d0_.plg_pu_private AS plg_pu_private_13, d0_.plg_pu_private_key AS plg_pu_private_key_14, d0_.plg_pu_publish_date AS plg_pu_publish_date_15, d0_.free_description_about_quantity AS free_description_about_quantity_16, d0_.free_description_about_selling_price AS free_description_about_selling_price_17, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_18, d0_.discriminator_type AS discriminator_type_19, d0_.creator_id AS creator_id_20, d0_.product_status_id AS product_status_id_21, d0_.schedule_time_id AS schedule_time_id_22 FROM dtb_product d0_ LEFT JOIN dtb_product_tag d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('producttag') WHERE (d0_.product_status_id = 1 AND d0_.priority_flag = 1 AND d1_.tag_id = 1) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC;

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-11-14 00:41:26' 
                and time_to > '2024-11-14 00:41:26'
              ) 
              or (
                time_from < '2024-11-14 00:41:26' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:26'
              ) 
              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-11-14 00:41:26' 
                  or time_to < '2024-11-14 00:41:26'
              ) 
              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-11-14 00:41:26' 
                and time_to > '2024-11-14 00:41:26'
              ) 
              or (
                time_from < '2024-11-14 00:41:26' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:26'
              ) 
              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-11-14 00:41:26' 
                  or time_to < '2024-11-14 00:41:26'
              ) 
              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-11-14 00:41:26' 
                and time_to > '2024-11-14 00:41:26'
              ) 
              or (
                time_from < '2024-11-14 00:41:26' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:26'
              ) 
              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-11-14 00:41:26' 
                  or time_to < '2024-11-14 00:41:26'
              ) 
              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-11-14 00:41:26' 
                and time_to > '2024-11-14 00:41:26'
              ) 
              or (
                time_from < '2024-11-14 00:41:26' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:26'
              ) 
              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-11-14 00:41:26' 
                  or time_to < '2024-11-14 00:41:26'
              ) 
              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-11-14 00:41:26' 
                  and time_to > '2024-11-14 00:41:26'
                ) 
                or (
                  time_from < '2024-11-14 00:41:26' 
                  and time_to is null
                ) 
                or (
                  time_from is null 
                  and time_to > '2024-11-14 00:41:26'
                ) 
                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-11-14 00:41:26' 
                    or time_to < '2024-11-14 00:41:26'
                ) 
                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-11-14 00:41:26' and time_to > '2024-11-14 00:41:26')
          or (time_from < '2024-11-14 00:41:26' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:26')
          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-11-14 00:41:26' or time_to < '2024-11-14 00:41:26'
          ) 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-11-14 00:41:26' and time_to > '2024-11-14 00:41:26')
          or (time_from < '2024-11-14 00:41:26' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:26')
          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-11-14 00:41:26' or time_to < '2024-11-14 00:41:26'
          ) 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-11-14 00:41:26' and time_to > '2024-11-14 00:41:26')
          or (time_from < '2024-11-14 00:41:26' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:26')
          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-11-14 00:41:26' or time_to < '2024-11-14 00:41:26'
          ) 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-11-14 00:41:26' and time_to > '2024-11-14 00:41:26')
          or (time_from < '2024-11-14 00:41:26' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:26')
          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-11-14 00:41:26' or time_to < '2024-11-14 00:41:26'
          ) 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-11-14 00:41:26' and time_to > '2024-11-14 00:41:26')
          or (time_from < '2024-11-14 00:41:26' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:26')
          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-11-14 00:41:26' or time_to < '2024-11-14 00:41:26'
          ) 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-11-14 00:41:25' 
                and time_to > '2024-11-14 00:41:25'
              ) 
              or (
                time_from < '2024-11-14 00:41:25' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  or time_to < '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                and time_to > '2024-11-14 00:41:25'
              ) 
              or (
                time_from < '2024-11-14 00:41:25' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  or time_to < '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                and time_to > '2024-11-14 00:41:25'
              ) 
              or (
                time_from < '2024-11-14 00:41:25' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  or time_to < '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                and time_to > '2024-11-14 00:41:25'
              ) 
              or (
                time_from < '2024-11-14 00:41:25' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  or time_to < '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  and time_to > '2024-11-14 00:41:25'
                ) 
                or (
                  time_from < '2024-11-14 00:41:25' 
                  and time_to is null
                ) 
                or (
                  time_from is null 
                  and time_to > '2024-11-14 00:41:25'
                ) 
                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-11-14 00:41:25' 
                    or time_to < '2024-11-14 00:41:25'
                ) 
                or chain_schedule_time_id is null
              )
          )
        )
      )
    )
  ) 
  AND d0_.discriminator_type IN ('category') 
ORDER BY 
  d0_.sort_no DESC, 
  d1_.sort_no DESC, 
  d2_.sort_no DESC, 
  d3_.sort_no DESC, 
  d4_.sort_no DESC

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-11-14 00:41:25' and time_to > '2024-11-14 00:41:25')
          or (time_from < '2024-11-14 00:41:25' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:25')
          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-11-14 00:41:25' or time_to < '2024-11-14 00:41:25'
          ) 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-11-14 00:41:25' and time_to > '2024-11-14 00:41:25')
          or (time_from < '2024-11-14 00:41:25' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:25')
          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-11-14 00:41:25' or time_to < '2024-11-14 00:41:25'
          ) 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-11-14 00:41:25' and time_to > '2024-11-14 00:41:25')
          or (time_from < '2024-11-14 00:41:25' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:25')
          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-11-14 00:41:25' or time_to < '2024-11-14 00:41:25'
          ) 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-11-14 00:41:25' and time_to > '2024-11-14 00:41:25')
          or (time_from < '2024-11-14 00:41:25' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:25')
          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-11-14 00:41:25' or time_to < '2024-11-14 00:41:25'
          ) 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-11-14 00:41:25' and time_to > '2024-11-14 00:41:25')
          or (time_from < '2024-11-14 00:41:25' and time_to is null)
          or (time_from is null and time_to > '2024-11-14 00:41:25')
          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-11-14 00:41:25' or time_to < '2024-11-14 00:41:25'
          ) or chain_schedule_time_id is null)  ) )))) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no DESC, d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no DESC;

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-11-14 00:41:25' 
                and time_to > '2024-11-14 00:41:25'
              ) 
              or (
                time_from < '2024-11-14 00:41:25' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  or time_to < '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                and time_to > '2024-11-14 00:41:25'
              ) 
              or (
                time_from < '2024-11-14 00:41:25' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  or time_to < '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                and time_to > '2024-11-14 00:41:25'
              ) 
              or (
                time_from < '2024-11-14 00:41:25' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  or time_to < '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                and time_to > '2024-11-14 00:41:25'
              ) 
              or (
                time_from < '2024-11-14 00:41:25' 
                and time_to is null
              ) 
              or (
                time_from is null 
                and time_to > '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  or time_to < '2024-11-14 00:41:25'
              ) 
              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-11-14 00:41:25' 
                  and time_to > '2024-11-14 00:41:25'
                ) 
                or (
                  time_from < '2024-11-14 00:41:25' 
                  and time_to is null
                ) 
                or (
                  time_from is null 
                  and time_to > '2024-11-14 00:41:25'
                ) 
                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-11-14 00:41:25' 
                    or time_to < '2024-11-14 00:41:25'
                ) 
                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