Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.quantity AS quantity_2, 
  t0.description AS description_3, 
  t0.price_view AS price_view_4, 
  t0.direct_select AS direct_select_5, 
  t0.product_id AS product_id_6 
FROM 
  plg_ks_product t0 
WHERE 
  t0.product_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.description AS description_3, t0.price_view AS price_view_4, t0.direct_select AS direct_select_5, t0.product_id AS product_id_6 FROM plg_ks_product t0 WHERE t0.product_id = 5;

SELECT 
  t0.id AS id_1, 
  t0.select_only AS select_only_2, 
  t0.product_id AS product_id_3 
FROM 
  plg_ks_product_option t0 
WHERE 
  t0.product_id = ?

SELECT t0.id AS id_1, t0.select_only AS select_only_2, t0.product_id AS product_id_3 FROM plg_ks_product_option t0 WHERE t0.product_id = 5;

SELECT 
  avg(p0_.recommend_level) AS sclr_0, 
  count(p0_.id) AS sclr_1 
FROM 
  plg_product_review p0_ 
  LEFT JOIN dtb_product d1_ ON p0_.product_id = d1_.id 
  AND d1_.discriminator_type IN ('product') 
WHERE 
  p0_.product_id = ? 
  AND p0_.status_id = 1 
GROUP BY 
  p0_.product_id

SELECT avg(p0_.recommend_level) AS sclr_0, count(p0_.id) AS sclr_1 FROM plg_product_review p0_ LEFT JOIN dtb_product d1_ ON p0_.product_id = d1_.id AND d1_.discriminator_type IN ('product') WHERE p0_.product_id = 360 AND p0_.status_id = 1 GROUP BY p0_.product_id;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.sort_no AS sort_no_3, 
  t0.create_date AS create_date_4, 
  t0.category AS category_5, 
  t0.product_id AS product_id_6, 
  t0.creator_id AS creator_id_7, 
  t0.discriminator_type 
FROM 
  dtb_product_image t0 
WHERE 
  t0.product_id = ? 
  AND t0.discriminator_type IN ('productimage') 
ORDER BY 
  t0.sort_no ASC

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.category AS category_5, t0.product_id AS product_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = 360 AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC;

SELECT 
  t0.id AS id_1, 
  t0.product_code AS product_code_2, 
  t0.stock AS stock_3, 
  t0.stock_unlimited AS stock_unlimited_4, 
  t0.sale_limit AS sale_limit_5, 
  t0.price01 AS price01_6, 
  t0.price02 AS price02_7, 
  t0.exclusive_tax_price AS exclusive_tax_price_8, 
  t0.delivery_fee AS delivery_fee_9, 
  t0.delivery_fee_free AS delivery_fee_free_10, 
  t0.visible AS visible_11, 
  t0.create_date AS create_date_12, 
  t0.update_date AS update_date_13, 
  t0.currency_code AS currency_code_14, 
  t0.point_rate AS point_rate_15, 
  t0.stripe_price_id AS stripe_price_id_16, 
  t0._interval AS _interval_17, 
  t0.bundle_product AS bundle_product_18, 
  t0.initial_price AS initial_price_19, 
  t0.first_cycle_free AS first_cycle_free_20, 
  t0.bundle_required AS bundle_required_21, 
  t0.product_id AS product_id_22, 
  t0.sale_type_id AS sale_type_id_23, 
  t0.class_category_id1 AS class_category_id1_24, 
  t0.class_category_id2 AS class_category_id2_25, 
  t0.delivery_duration_id AS delivery_duration_id_26, 
  t0.creator_id AS creator_id_27, 
  t0.regular_discount_id AS regular_discount_id_28, 
  t0.discriminator_type 
FROM 
  dtb_product_class t0 
WHERE 
  t0.product_id = ? 
  AND t0.discriminator_type IN ('productclass')

SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.exclusive_tax_price AS exclusive_tax_price_8, t0.delivery_fee AS delivery_fee_9, t0.delivery_fee_free AS delivery_fee_free_10, t0.visible AS visible_11, t0.create_date AS create_date_12, t0.update_date AS update_date_13, t0.currency_code AS currency_code_14, t0.point_rate AS point_rate_15, t0.stripe_price_id AS stripe_price_id_16, t0._interval AS _interval_17, t0.bundle_product AS bundle_product_18, t0.initial_price AS initial_price_19, t0.first_cycle_free AS first_cycle_free_20, t0.bundle_required AS bundle_required_21, t0.product_id AS product_id_22, t0.sale_type_id AS sale_type_id_23, t0.class_category_id1 AS class_category_id1_24, t0.class_category_id2 AS class_category_id2_25, t0.delivery_duration_id AS delivery_duration_id_26, t0.creator_id AS creator_id_27, t0.regular_discount_id AS regular_discount_id_28, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = 397 AND t0.discriminator_type IN ('productclass');

SELECT 
  d0_.id AS id_0, 
  d0_.name AS name_1, 
  d0_.slug AS slug_2, 
  d0_.note AS note_3, 
  d0_.description_list AS description_list_4, 
  d0_.description_detail AS description_detail_5, 
  d0_.search_word AS search_word_6, 
  d0_.free_area AS free_area_7, 
  d0_.create_date AS create_date_8, 
  d0_.update_date AS update_date_9, 
  d0_.is_variant AS is_variant_10, 
  d0_.slug_variant AS slug_variant_11, 
  d0_.tax_rate AS tax_rate_12, 
  d0_.is_separately AS is_separately_13, 
  d0_.need_auto_generate_review AS need_auto_generate_review_14, 
  d0_.page_views AS page_views_15, 
  d0_.llmo_target_audience AS llmo_target_audience_16, 
  d0_.llmo_problem_solution AS llmo_problem_solution_17, 
  d0_.llmo_usage_scene AS llmo_usage_scene_18, 
  d0_.llmo_supervised_comment AS llmo_supervised_comment_19, 
  d0_.llmo_how_to_use AS llmo_how_to_use_20, 
  d0_.llmo_features AS llmo_features_21, 
  d0_.llmo_faq AS llmo_faq_22, 
  d0_.plg_markdown_description_detail AS plg_markdown_description_detail_23, 
  d0_.plg_markdown_free_area AS plg_markdown_free_area_24, 
  d0_.sheeb_download_content AS sheeb_download_content_25, 
  d0_.sheeb_dlc_mime AS sheeb_dlc_mime_26, 
  d0_.sheeb_dlc_save_url AS sheeb_dlc_save_url_27, 
  d0_.sheeb_dlc_origin_file_name AS sheeb_dlc_origin_file_name_28, 
  d0_.sheeb_dlc_download_due_days AS sheeb_dlc_download_due_days_29, 
  d0_.sheeb_dlc_viewing_days AS sheeb_dlc_viewing_days_30, 
  d0_.sheeb_dlc_downloadable_count AS sheeb_dlc_downloadable_count_31, 
  d0_.rank_price AS rank_price_32, 
  d0_.regular_product_id AS regular_product_id_33, 
  d0_.owner_product_id AS owner_product_id_34, 
  d0_.owner_rank AS owner_rank_35, 
  d0_.product_sub_name AS product_sub_name_36, 
  d0_.stripe_prod_id AS stripe_prod_id_37, 
  d0_.discriminator_type AS discriminator_type_38, 
  d0_.creator_id AS creator_id_39, 
  d0_.product_status_id AS product_status_id_40, 
  d0_.owner_product_id AS owner_product_id_41, 
  d0_.regular_product_id AS regular_product_id_42 
FROM 
  dtb_product d0_ 
  INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id 
  AND d1_.discriminator_type IN ('productcategory') 
  INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id 
  AND d2_.discriminator_type IN ('category') 
  INNER JOIN dtb_product_class d3_ ON d0_.id = d3_.product_id 
  AND d3_.discriminator_type IN ('productclass') 
  LEFT JOIN plg_product_pinpoint p4_ ON (p4_.product_class_id = d3_.id) 
  LEFT JOIN plg_pinpoint p5_ ON (p5_.id = p4_.pinpoint_id) 
WHERE 
  (
    d0_.product_status_id = 1 
    AND d1_.category_id IN (?) 
    AND (
      NOT (
        EXISTS (
          SELECT 
            p6_.id 
          FROM 
            plg_ks_product_option p6_ 
          WHERE 
            p6_.product_id = d0_.id 
            AND p6_.select_only = 1
        )
      )
    )
  ) 
  AND d0_.discriminator_type IN ('product') 
ORDER BY 
  p5_.end_time ASC 
LIMIT 
  999

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2, d0_.note AS note_3, d0_.description_list AS description_list_4, d0_.description_detail AS description_detail_5, d0_.search_word AS search_word_6, d0_.free_area AS free_area_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.is_variant AS is_variant_10, d0_.slug_variant AS slug_variant_11, d0_.tax_rate AS tax_rate_12, d0_.is_separately AS is_separately_13, d0_.need_auto_generate_review AS need_auto_generate_review_14, d0_.page_views AS page_views_15, d0_.llmo_target_audience AS llmo_target_audience_16, d0_.llmo_problem_solution AS llmo_problem_solution_17, d0_.llmo_usage_scene AS llmo_usage_scene_18, d0_.llmo_supervised_comment AS llmo_supervised_comment_19, d0_.llmo_how_to_use AS llmo_how_to_use_20, d0_.llmo_features AS llmo_features_21, d0_.llmo_faq AS llmo_faq_22, d0_.plg_markdown_description_detail AS plg_markdown_description_detail_23, d0_.plg_markdown_free_area AS plg_markdown_free_area_24, d0_.sheeb_download_content AS sheeb_download_content_25, d0_.sheeb_dlc_mime AS sheeb_dlc_mime_26, d0_.sheeb_dlc_save_url AS sheeb_dlc_save_url_27, d0_.sheeb_dlc_origin_file_name AS sheeb_dlc_origin_file_name_28, d0_.sheeb_dlc_download_due_days AS sheeb_dlc_download_due_days_29, d0_.sheeb_dlc_viewing_days AS sheeb_dlc_viewing_days_30, d0_.sheeb_dlc_downloadable_count AS sheeb_dlc_downloadable_count_31, d0_.rank_price AS rank_price_32, d0_.regular_product_id AS regular_product_id_33, d0_.owner_product_id AS owner_product_id_34, d0_.owner_rank AS owner_rank_35, d0_.product_sub_name AS product_sub_name_36, d0_.stripe_prod_id AS stripe_prod_id_37, d0_.discriminator_type AS discriminator_type_38, d0_.creator_id AS creator_id_39, d0_.product_status_id AS product_status_id_40, d0_.owner_product_id AS owner_product_id_41, d0_.regular_product_id AS regular_product_id_42 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') INNER JOIN dtb_product_class d3_ ON d0_.id = d3_.product_id AND d3_.discriminator_type IN ('productclass') LEFT JOIN plg_product_pinpoint p4_ ON (p4_.product_class_id = d3_.id) LEFT JOIN plg_pinpoint p5_ ON (p5_.id = p4_.pinpoint_id) WHERE (d0_.product_status_id = 1 AND d1_.category_id IN (40) AND (NOT (EXISTS (SELECT p6_.id FROM plg_ks_product_option p6_ WHERE p6_.product_id = d0_.id AND p6_.select_only = 1)))) AND d0_.discriminator_type IN ('product') ORDER BY p5_.end_time ASC LIMIT 999;

SELECT 
  t0.id AS id_1, 
  t0.stock AS stock_2, 
  t0.create_date AS create_date_3, 
  t0.update_date AS update_date_4, 
  t0.product_class_id AS product_class_id_5, 
  t0.creator_id AS creator_id_6, 
  t0.discriminator_type 
FROM 
  dtb_product_stock t0 
WHERE 
  t0.product_class_id = ? 
  AND t0.discriminator_type IN ('productstock')

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = 420 AND t0.discriminator_type IN ('productstock');

SELECT 
  t0.id AS id_1, 
  t0.tax_rate AS tax_rate_2, 
  t0.tax_adjust AS tax_adjust_3, 
  t0.apply_date AS apply_date_4, 
  t0.create_date AS create_date_5, 
  t0.update_date AS update_date_6, 
  t0.product_class_id AS product_class_id_7, 
  t0.creator_id AS creator_id_8, 
  t0.country_id AS country_id_9, 
  t0.pref_id AS pref_id_10, 
  t0.product_id AS product_id_11, 
  t0.rounding_type_id AS rounding_type_id_12, 
  t0.discriminator_type 
FROM 
  dtb_tax_rule t0 
WHERE 
  t0.product_class_id = ? 
  AND t0.discriminator_type IN ('taxrule')

SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = 420 AND t0.discriminator_type IN ('taxrule');

SELECT 
  t0.id AS id_1, 
  t0.pinpoint_id AS pinpoint_id_2, 
  t0.product_class_id AS product_class_id_3 
FROM 
  plg_product_pinpoint t0 
WHERE 
  t0.product_class_id = ?

SELECT t0.id AS id_1, t0.pinpoint_id AS pinpoint_id_2, t0.product_class_id AS product_class_id_3 FROM plg_product_pinpoint t0 WHERE t0.product_class_id = 420;

SELECT 
  d0_.id AS id_0, 
  d0_.name AS name_1, 
  d0_.slug AS slug_2, 
  d0_.note AS note_3, 
  d0_.description_list AS description_list_4, 
  d0_.description_detail AS description_detail_5, 
  d0_.search_word AS search_word_6, 
  d0_.free_area AS free_area_7, 
  d0_.create_date AS create_date_8, 
  d0_.update_date AS update_date_9, 
  d0_.is_variant AS is_variant_10, 
  d0_.slug_variant AS slug_variant_11, 
  d0_.tax_rate AS tax_rate_12, 
  d0_.is_separately AS is_separately_13, 
  d0_.need_auto_generate_review AS need_auto_generate_review_14, 
  d0_.page_views AS page_views_15, 
  d0_.llmo_target_audience AS llmo_target_audience_16, 
  d0_.llmo_problem_solution AS llmo_problem_solution_17, 
  d0_.llmo_usage_scene AS llmo_usage_scene_18, 
  d0_.llmo_supervised_comment AS llmo_supervised_comment_19, 
  d0_.llmo_how_to_use AS llmo_how_to_use_20, 
  d0_.llmo_features AS llmo_features_21, 
  d0_.llmo_faq AS llmo_faq_22, 
  d0_.plg_markdown_description_detail AS plg_markdown_description_detail_23, 
  d0_.plg_markdown_free_area AS plg_markdown_free_area_24, 
  d0_.sheeb_download_content AS sheeb_download_content_25, 
  d0_.sheeb_dlc_mime AS sheeb_dlc_mime_26, 
  d0_.sheeb_dlc_save_url AS sheeb_dlc_save_url_27, 
  d0_.sheeb_dlc_origin_file_name AS sheeb_dlc_origin_file_name_28, 
  d0_.sheeb_dlc_download_due_days AS sheeb_dlc_download_due_days_29, 
  d0_.sheeb_dlc_viewing_days AS sheeb_dlc_viewing_days_30, 
  d0_.sheeb_dlc_downloadable_count AS sheeb_dlc_downloadable_count_31, 
  d0_.rank_price AS rank_price_32, 
  d0_.regular_product_id AS regular_product_id_33, 
  d0_.owner_product_id AS owner_product_id_34, 
  d0_.owner_rank AS owner_rank_35, 
  d0_.product_sub_name AS product_sub_name_36, 
  d0_.stripe_prod_id AS stripe_prod_id_37, 
  d0_.discriminator_type AS discriminator_type_38, 
  d0_.creator_id AS creator_id_39, 
  d0_.product_status_id AS product_status_id_40, 
  d0_.owner_product_id AS owner_product_id_41, 
  d0_.regular_product_id AS regular_product_id_42 
FROM 
  dtb_product d0_ 
  INNER JOIN plg_product_variant p1_ ON d0_.id = p1_.product_id 
  AND p1_.discriminator_type IN ('productvariant') 
WHERE 
  (p1_.child_product_id = ?) 
  AND d0_.discriminator_type IN ('product') 
ORDER BY 
  p1_.id DESC 
LIMIT 
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2, d0_.note AS note_3, d0_.description_list AS description_list_4, d0_.description_detail AS description_detail_5, d0_.search_word AS search_word_6, d0_.free_area AS free_area_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.is_variant AS is_variant_10, d0_.slug_variant AS slug_variant_11, d0_.tax_rate AS tax_rate_12, d0_.is_separately AS is_separately_13, d0_.need_auto_generate_review AS need_auto_generate_review_14, d0_.page_views AS page_views_15, d0_.llmo_target_audience AS llmo_target_audience_16, d0_.llmo_problem_solution AS llmo_problem_solution_17, d0_.llmo_usage_scene AS llmo_usage_scene_18, d0_.llmo_supervised_comment AS llmo_supervised_comment_19, d0_.llmo_how_to_use AS llmo_how_to_use_20, d0_.llmo_features AS llmo_features_21, d0_.llmo_faq AS llmo_faq_22, d0_.plg_markdown_description_detail AS plg_markdown_description_detail_23, d0_.plg_markdown_free_area AS plg_markdown_free_area_24, d0_.sheeb_download_content AS sheeb_download_content_25, d0_.sheeb_dlc_mime AS sheeb_dlc_mime_26, d0_.sheeb_dlc_save_url AS sheeb_dlc_save_url_27, d0_.sheeb_dlc_origin_file_name AS sheeb_dlc_origin_file_name_28, d0_.sheeb_dlc_download_due_days AS sheeb_dlc_download_due_days_29, d0_.sheeb_dlc_viewing_days AS sheeb_dlc_viewing_days_30, d0_.sheeb_dlc_downloadable_count AS sheeb_dlc_downloadable_count_31, d0_.rank_price AS rank_price_32, d0_.regular_product_id AS regular_product_id_33, d0_.owner_product_id AS owner_product_id_34, d0_.owner_rank AS owner_rank_35, d0_.product_sub_name AS product_sub_name_36, d0_.stripe_prod_id AS stripe_prod_id_37, d0_.discriminator_type AS discriminator_type_38, d0_.creator_id AS creator_id_39, d0_.product_status_id AS product_status_id_40, d0_.owner_product_id AS owner_product_id_41, d0_.regular_product_id AS regular_product_id_42 FROM dtb_product d0_ INNER JOIN plg_product_variant p1_ ON d0_.id = p1_.product_id AND p1_.discriminator_type IN ('productvariant') WHERE (p1_.child_product_id = 360) AND d0_.discriminator_type IN ('product') ORDER BY p1_.id DESC LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.slug AS slug_3, 
  t0.note AS note_4, 
  t0.description_list AS description_list_5, 
  t0.description_detail AS description_detail_6, 
  t0.search_word AS search_word_7, 
  t0.free_area AS free_area_8, 
  t0.create_date AS create_date_9, 
  t0.update_date AS update_date_10, 
  t0.is_variant AS is_variant_11, 
  t0.slug_variant AS slug_variant_12, 
  t0.tax_rate AS tax_rate_13, 
  t0.is_separately AS is_separately_14, 
  t0.need_auto_generate_review AS need_auto_generate_review_15, 
  t0.page_views AS page_views_16, 
  t0.llmo_target_audience AS llmo_target_audience_17, 
  t0.llmo_problem_solution AS llmo_problem_solution_18, 
  t0.llmo_usage_scene AS llmo_usage_scene_19, 
  t0.llmo_supervised_comment AS llmo_supervised_comment_20, 
  t0.llmo_how_to_use AS llmo_how_to_use_21, 
  t0.llmo_features AS llmo_features_22, 
  t0.llmo_faq AS llmo_faq_23, 
  t0.plg_markdown_description_detail AS plg_markdown_description_detail_24, 
  t0.plg_markdown_free_area AS plg_markdown_free_area_25, 
  t0.sheeb_download_content AS sheeb_download_content_26, 
  t0.sheeb_dlc_mime AS sheeb_dlc_mime_27, 
  t0.sheeb_dlc_save_url AS sheeb_dlc_save_url_28, 
  t0.sheeb_dlc_origin_file_name AS sheeb_dlc_origin_file_name_29, 
  t0.sheeb_dlc_download_due_days AS sheeb_dlc_download_due_days_30, 
  t0.sheeb_dlc_viewing_days AS sheeb_dlc_viewing_days_31, 
  t0.sheeb_dlc_downloadable_count AS sheeb_dlc_downloadable_count_32, 
  t0.rank_price AS rank_price_33, 
  t0.regular_product_id AS regular_product_id_34, 
  t0.owner_product_id AS owner_product_id_35, 
  t0.owner_rank AS owner_rank_36, 
  t0.product_sub_name AS product_sub_name_37, 
  t0.stripe_prod_id AS stripe_prod_id_38, 
  t0.creator_id AS creator_id_39, 
  t0.product_status_id AS product_status_id_40, 
  t42.id AS id_41, 
  t42.quantity AS quantity_43, 
  t42.description AS description_44, 
  t42.price_view AS price_view_45, 
  t42.direct_select AS direct_select_46, 
  t42.product_id AS product_id_47, 
  t49.id AS id_48, 
  t49.select_only AS select_only_50, 
  t49.product_id AS product_id_51, 
  t0.owner_product_id AS owner_product_id_52, 
  t0.regular_product_id AS regular_product_id_53, 
  t0.discriminator_type 
FROM 
  dtb_product t0 
  LEFT JOIN plg_ks_product t42 ON t42.product_id = t0.id 
  LEFT JOIN plg_ks_product_option t49 ON t49.product_id = t0.id 
WHERE 
  t0.id = ? 
  AND t0.discriminator_type IN ('product')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.note AS note_4, t0.description_list AS description_list_5, t0.description_detail AS description_detail_6, t0.search_word AS search_word_7, t0.free_area AS free_area_8, t0.create_date AS create_date_9, t0.update_date AS update_date_10, t0.is_variant AS is_variant_11, t0.slug_variant AS slug_variant_12, t0.tax_rate AS tax_rate_13, t0.is_separately AS is_separately_14, t0.need_auto_generate_review AS need_auto_generate_review_15, t0.page_views AS page_views_16, t0.llmo_target_audience AS llmo_target_audience_17, t0.llmo_problem_solution AS llmo_problem_solution_18, t0.llmo_usage_scene AS llmo_usage_scene_19, t0.llmo_supervised_comment AS llmo_supervised_comment_20, t0.llmo_how_to_use AS llmo_how_to_use_21, t0.llmo_features AS llmo_features_22, t0.llmo_faq AS llmo_faq_23, t0.plg_markdown_description_detail AS plg_markdown_description_detail_24, t0.plg_markdown_free_area AS plg_markdown_free_area_25, t0.sheeb_download_content AS sheeb_download_content_26, t0.sheeb_dlc_mime AS sheeb_dlc_mime_27, t0.sheeb_dlc_save_url AS sheeb_dlc_save_url_28, t0.sheeb_dlc_origin_file_name AS sheeb_dlc_origin_file_name_29, t0.sheeb_dlc_download_due_days AS sheeb_dlc_download_due_days_30, t0.sheeb_dlc_viewing_days AS sheeb_dlc_viewing_days_31, t0.sheeb_dlc_downloadable_count AS sheeb_dlc_downloadable_count_32, t0.rank_price AS rank_price_33, t0.regular_product_id AS regular_product_id_34, t0.owner_product_id AS owner_product_id_35, t0.owner_rank AS owner_rank_36, t0.product_sub_name AS product_sub_name_37, t0.stripe_prod_id AS stripe_prod_id_38, t0.creator_id AS creator_id_39, t0.product_status_id AS product_status_id_40, t42.id AS id_41, t42.quantity AS quantity_43, t42.description AS description_44, t42.price_view AS price_view_45, t42.direct_select AS direct_select_46, t42.product_id AS product_id_47, t49.id AS id_48, t49.select_only AS select_only_50, t49.product_id AS product_id_51, t0.owner_product_id AS owner_product_id_52, t0.regular_product_id AS regular_product_id_53, t0.discriminator_type FROM dtb_product t0 LEFT JOIN plg_ks_product t42 ON t42.product_id = t0.id LEFT JOIN plg_ks_product_option t49 ON t49.product_id = t0.id WHERE t0.id = 360 AND t0.discriminator_type IN ('product');

SELECT 
  t0.id AS id_1, 
  t0.category_name AS category_name_2, 
  t0.hierarchy AS hierarchy_3, 
  t0.sort_no AS sort_no_4, 
  t0.create_date AS create_date_5, 
  t0.update_date AS update_date_6, 
  t0.visible AS visible_7, 
  t0.parent_category_id AS parent_category_id_8, 
  t0.creator_id AS creator_id_9, 
  t0.discriminator_type 
FROM 
  dtb_category t0 
WHERE 
  t0.parent_category_id = ? 
  AND t0.discriminator_type IN ('category') 
ORDER BY 
  t0.sort_no DESC

SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.visible AS visible_7, t0.parent_category_id AS parent_category_id_8, t0.creator_id AS creator_id_9, t0.discriminator_type FROM dtb_category t0 WHERE t0.parent_category_id = 87 AND t0.discriminator_type IN ('category') ORDER BY t0.sort_no DESC;

SELECT 
  t0.id AS id_1, 
  t0.sale_type AS sale_type_2, 
  t0.sale_price AS sale_price_3, 
  t0.sale_rate AS sale_rate_4, 
  t0.start_time AS start_time_5, 
  t0.end_time AS end_time_6, 
  t0.name AS name_7, 
  t0.sort_no AS sort_no_8, 
  t0.repeat_id AS repeat_id_9 
FROM 
  plg_pinpoint t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.sale_type AS sale_type_2, t0.sale_price AS sale_price_3, t0.sale_rate AS sale_rate_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.name AS name_7, t0.sort_no AS sort_no_8, t0.repeat_id AS repeat_id_9 FROM plg_pinpoint t0 WHERE t0.id = 450;

SELECT 
  count(DISTINCT p0_.id) AS sclr_0 
FROM 
  plg_product_review p0_ 
  INNER JOIN dtb_product d1_ ON (p0_.product_id = d1_.id) 
  AND d1_.discriminator_type IN ('product') 
  INNER JOIN dtb_product_category d2_ ON (d2_.product_id = d1_.id) 
  AND d2_.discriminator_type IN ('productcategory') 
WHERE 
  p0_.status_id = 1 
  AND d2_.category_id = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM plg_product_review p0_ INNER JOIN dtb_product d1_ ON (p0_.product_id = d1_.id) AND d1_.discriminator_type IN ('product') INNER JOIN dtb_product_category d2_ ON (d2_.product_id = d1_.id) AND d2_.discriminator_type IN ('productcategory') WHERE p0_.status_id = 1 AND d2_.category_id = '22';

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_.visible AS visible_6, 
  d1_.id AS id_7, 
  d1_.category_name AS category_name_8, 
  d1_.hierarchy AS hierarchy_9, 
  d1_.sort_no AS sort_no_10, 
  d1_.create_date AS create_date_11, 
  d1_.update_date AS update_date_12, 
  d1_.visible AS visible_13, 
  d2_.id AS id_14, 
  d2_.category_name AS category_name_15, 
  d2_.hierarchy AS hierarchy_16, 
  d2_.sort_no AS sort_no_17, 
  d2_.create_date AS create_date_18, 
  d2_.update_date AS update_date_19, 
  d2_.visible AS visible_20, 
  d3_.id AS id_21, 
  d3_.category_name AS category_name_22, 
  d3_.hierarchy AS hierarchy_23, 
  d3_.sort_no AS sort_no_24, 
  d3_.create_date AS create_date_25, 
  d3_.update_date AS update_date_26, 
  d3_.visible AS visible_27, 
  d4_.id AS id_28, 
  d4_.category_name AS category_name_29, 
  d4_.hierarchy AS hierarchy_30, 
  d4_.sort_no AS sort_no_31, 
  d4_.create_date AS create_date_32, 
  d4_.update_date AS update_date_33, 
  d4_.visible AS visible_34, 
  d0_.discriminator_type AS discriminator_type_35, 
  d0_.parent_category_id AS parent_category_id_36, 
  d0_.creator_id AS creator_id_37, 
  d1_.discriminator_type AS discriminator_type_38, 
  d1_.parent_category_id AS parent_category_id_39, 
  d1_.creator_id AS creator_id_40, 
  d2_.discriminator_type AS discriminator_type_41, 
  d2_.parent_category_id AS parent_category_id_42, 
  d2_.creator_id AS creator_id_43, 
  d3_.discriminator_type AS discriminator_type_44, 
  d3_.parent_category_id AS parent_category_id_45, 
  d3_.creator_id AS creator_id_46, 
  d4_.discriminator_type AS discriminator_type_47, 
  d4_.parent_category_id AS parent_category_id_48, 
  d4_.creator_id AS creator_id_49 
FROM 
  dtb_category d0_ 
  LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id 
  AND d1_.discriminator_type IN ('category') 
  LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id 
  AND d2_.discriminator_type IN ('category') 
  LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id 
  AND d3_.discriminator_type IN ('category') 
  LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id 
  AND d4_.discriminator_type IN ('category') 
WHERE 
  (d0_.parent_category_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_.visible AS visible_6, d1_.id AS id_7, d1_.category_name AS category_name_8, d1_.hierarchy AS hierarchy_9, d1_.sort_no AS sort_no_10, d1_.create_date AS create_date_11, d1_.update_date AS update_date_12, d1_.visible AS visible_13, d2_.id AS id_14, d2_.category_name AS category_name_15, d2_.hierarchy AS hierarchy_16, d2_.sort_no AS sort_no_17, d2_.create_date AS create_date_18, d2_.update_date AS update_date_19, d2_.visible AS visible_20, d3_.id AS id_21, d3_.category_name AS category_name_22, d3_.hierarchy AS hierarchy_23, d3_.sort_no AS sort_no_24, d3_.create_date AS create_date_25, d3_.update_date AS update_date_26, d3_.visible AS visible_27, d4_.id AS id_28, d4_.category_name AS category_name_29, d4_.hierarchy AS hierarchy_30, d4_.sort_no AS sort_no_31, d4_.create_date AS create_date_32, d4_.update_date AS update_date_33, d4_.visible AS visible_34, d0_.discriminator_type AS discriminator_type_35, d0_.parent_category_id AS parent_category_id_36, d0_.creator_id AS creator_id_37, d1_.discriminator_type AS discriminator_type_38, d1_.parent_category_id AS parent_category_id_39, d1_.creator_id AS creator_id_40, d2_.discriminator_type AS discriminator_type_41, d2_.parent_category_id AS parent_category_id_42, d2_.creator_id AS creator_id_43, d3_.discriminator_type AS discriminator_type_44, d3_.parent_category_id AS parent_category_id_45, d3_.creator_id AS creator_id_46, d4_.discriminator_type AS discriminator_type_47, d4_.parent_category_id AS parent_category_id_48, d4_.creator_id AS creator_id_49 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') WHERE (d0_.parent_category_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 
  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')

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 = 360 AND t0.discriminator_type IN ('productcategory');

SELECT 
  DISTINCT p0_.id AS id_0, 
  p0_.recommend_level AS recommend_level_1, 
  p0_.id AS id_2 
FROM 
  plg_product_review p0_ 
  INNER JOIN dtb_product d1_ ON (p0_.product_id = d1_.id) 
  AND d1_.discriminator_type IN ('product') 
  INNER JOIN dtb_product_category d2_ ON (d2_.product_id = d1_.id) 
  AND d2_.discriminator_type IN ('productcategory') 
WHERE 
  p0_.status_id = 1 
  AND d2_.category_id = ? 
ORDER BY 
  p0_.recommend_level DESC, 
  p0_.id DESC 
LIMIT 
  10 OFFSET 60

SELECT DISTINCT p0_.id AS id_0, p0_.recommend_level AS recommend_level_1, p0_.id AS id_2 FROM plg_product_review p0_ INNER JOIN dtb_product d1_ ON (p0_.product_id = d1_.id) AND d1_.discriminator_type IN ('product') INNER JOIN dtb_product_category d2_ ON (d2_.product_id = d1_.id) AND d2_.discriminator_type IN ('productcategory') WHERE p0_.status_id = 1 AND d2_.category_id = '22' ORDER BY p0_.recommend_level DESC, p0_.id DESC LIMIT 10 OFFSET 60;

SELECT 
  t0.id AS id_1, 
  t0.category_name AS category_name_2, 
  t0.hierarchy AS hierarchy_3, 
  t0.sort_no AS sort_no_4, 
  t0.create_date AS create_date_5, 
  t0.update_date AS update_date_6, 
  t0.visible AS visible_7, 
  t0.parent_category_id AS parent_category_id_8, 
  t0.creator_id AS creator_id_9, 
  t0.discriminator_type 
FROM 
  dtb_category t0 
WHERE 
  t0.id = ? 
  AND t0.discriminator_type IN ('category')

SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.visible AS visible_7, t0.parent_category_id AS parent_category_id_8, t0.creator_id AS creator_id_9, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = 40 AND t0.discriminator_type IN ('category');