Symfony Profiler

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_.freeshipping_flg AS freeshipping_flg_9,
  d0_.comment1 AS comment1_10,
  d0_.comment2 AS comment2_11,
  d0_.comment3 AS comment3_12,
  d0_.comment4 AS comment4_13,
  d0_.comment5 AS comment5_14,
  d0_.comment6 AS comment6_15,
  d0_.main_list_comment AS main_list_comment_16,
  d0_.main_comment AS main_comment_17,
  d0_.sub_title1 AS sub_title1_18,
  d0_.sub_comment1 AS sub_comment1_19,
  d0_.sub_image1 AS sub_image1_20,
  d0_.sub_large_image1 AS sub_large_image1_21,
  d0_.sub_title2 AS sub_title2_22,
  d0_.sub_comment2 AS sub_comment2_23,
  d0_.sub_image2 AS sub_image2_24,
  d0_.sub_large_image2 AS sub_large_image2_25,
  d0_.sub_title3 AS sub_title3_26,
  d0_.sub_comment3 AS sub_comment3_27,
  d0_.sub_image3 AS sub_image3_28,
  d0_.sub_large_image3 AS sub_large_image3_29,
  d0_.sub_title4 AS sub_title4_30,
  d0_.sub_comment4 AS sub_comment4_31,
  d0_.sub_image4 AS sub_image4_32,
  d0_.sub_large_image4 AS sub_large_image4_33,
  d0_.sub_title5 AS sub_title5_34,
  d0_.sub_comment5 AS sub_comment5_35,
  d0_.sub_image5 AS sub_image5_36,
  d0_.sub_large_image5 AS sub_large_image5_37,
  d0_.sub_title6 AS sub_title6_38,
  d0_.sub_comment6 AS sub_comment6_39,
  d0_.sub_image6 AS sub_image6_40,
  d0_.sub_large_image6 AS sub_large_image6_41,
  d0_.sub_title7 AS sub_title7_42,
  d0_.sub_comment7 AS sub_comment7_43,
  d0_.sub_image7 AS sub_image7_44,
  d0_.sub_large_image7 AS sub_large_image7_45,
  d0_.sub_title8 AS sub_title8_46,
  d0_.sub_comment8 AS sub_comment8_47,
  d0_.sub_image8 AS sub_image8_48,
  d0_.sub_large_image8 AS sub_large_image8_49,
  d0_.sub_title9 AS sub_title9_50,
  d0_.sub_comment9 AS sub_comment9_51,
  d0_.sub_image9 AS sub_image9_52,
  d0_.sub_large_image9 AS sub_large_image9_53,
  d0_.sub_title10 AS sub_title10_54,
  d0_.sub_comment10 AS sub_comment10_55,
  d0_.sub_image10 AS sub_image10_56,
  d0_.sub_large_image10 AS sub_large_image10_57,
  d0_.papc3 AS papc3_58,
  d0_.papc4 AS papc4_59,
  d0_.papc7 AS papc7_60,
  d0_.papc11 AS papc11_61,
  d0_.papc12 AS papc12_62,
  d0_.papc13 AS papc13_63,
  d0_.papc14 AS papc14_64,
  d0_.papc15 AS papc15_65,
  d0_.papc16 AS papc16_66,
  d0_.papc18 AS papc18_67,
  d0_.artist_name AS artist_name_68,
  d0_.plg_deliveryfreeproduct AS plg_deliveryfreeproduct_69,
  d0_.shipping_name AS shipping_name_70,
  d0_.discriminator_type AS discriminator_type_71,
  d0_.creator_id AS creator_id_72,
  d0_.product_status_id AS product_status_id_73,
  d0_.papc2 AS papc2_74,
  d0_.schedule_time_id AS schedule_time_id_75
FROM
  dtb_product d0_
  INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id
  AND d1_.discriminator_type IN ('productclass')
  INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id
  AND d2_.discriminator_type IN ('productcategory')
  INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id
  AND d3_.discriminator_type IN ('category')
  LEFT JOIN plg_schedule_time p4_ ON d0_.schedule_time_id = p4_.schedule_time_id
  INNER JOIN dtb_product_class d5_ ON d0_.id = d5_.product_id
  AND d5_.discriminator_type IN ('productclass')
WHERE
  (
    d0_.product_status_id = 1
    AND d2_.category_id IN (?)
    AND (
      (
        p4_.schedule_type IS NULL
        OR p4_.schedule_type = ?
        AND (
          (
            p4_.time_from <= ?
            AND p4_.time_to > ?
          )
          OR (
            p4_.time_from <= ?
            AND p4_.time_to IS NULL
          )
          OR (
            p4_.time_from IS NULL
            AND p4_.time_to > ?
          )
          OR (
            p4_.time_from IS NULL
            AND p4_.time_to IS NULL
          )
          OR (p4_.view_flg = 1)
        )
      )
      OR (
        p4_.schedule_type IS NULL
        OR p4_.schedule_type = ?
        AND (
          (
            p4_.time_only_from <= ?
            AND p4_.time_only_to > ?
          )
          OR (
            p4_.time_only_from <= ?
            AND p4_.time_only_to IS NULL
          )
          OR (
            p4_.time_only_from IS NULL
            AND p4_.time_only_to > ?
          )
          OR (
            p4_.time_only_from IS NULL
            AND p4_.time_only_to IS NULL
          )
          OR (p4_.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 d5_.sale_type_id <> ?
    AND d0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
  )
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d0_.create_date DESC,
  d0_.id 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_.freeshipping_flg AS freeshipping_flg_9, d0_.comment1 AS comment1_10, d0_.comment2 AS comment2_11, d0_.comment3 AS comment3_12, d0_.comment4 AS comment4_13, d0_.comment5 AS comment5_14, d0_.comment6 AS comment6_15, d0_.main_list_comment AS main_list_comment_16, d0_.main_comment AS main_comment_17, d0_.sub_title1 AS sub_title1_18, d0_.sub_comment1 AS sub_comment1_19, d0_.sub_image1 AS sub_image1_20, d0_.sub_large_image1 AS sub_large_image1_21, d0_.sub_title2 AS sub_title2_22, d0_.sub_comment2 AS sub_comment2_23, d0_.sub_image2 AS sub_image2_24, d0_.sub_large_image2 AS sub_large_image2_25, d0_.sub_title3 AS sub_title3_26, d0_.sub_comment3 AS sub_comment3_27, d0_.sub_image3 AS sub_image3_28, d0_.sub_large_image3 AS sub_large_image3_29, d0_.sub_title4 AS sub_title4_30, d0_.sub_comment4 AS sub_comment4_31, d0_.sub_image4 AS sub_image4_32, d0_.sub_large_image4 AS sub_large_image4_33, d0_.sub_title5 AS sub_title5_34, d0_.sub_comment5 AS sub_comment5_35, d0_.sub_image5 AS sub_image5_36, d0_.sub_large_image5 AS sub_large_image5_37, d0_.sub_title6 AS sub_title6_38, d0_.sub_comment6 AS sub_comment6_39, d0_.sub_image6 AS sub_image6_40, d0_.sub_large_image6 AS sub_large_image6_41, d0_.sub_title7 AS sub_title7_42, d0_.sub_comment7 AS sub_comment7_43, d0_.sub_image7 AS sub_image7_44, d0_.sub_large_image7 AS sub_large_image7_45, d0_.sub_title8 AS sub_title8_46, d0_.sub_comment8 AS sub_comment8_47, d0_.sub_image8 AS sub_image8_48, d0_.sub_large_image8 AS sub_large_image8_49, d0_.sub_title9 AS sub_title9_50, d0_.sub_comment9 AS sub_comment9_51, d0_.sub_image9 AS sub_image9_52, d0_.sub_large_image9 AS sub_large_image9_53, d0_.sub_title10 AS sub_title10_54, d0_.sub_comment10 AS sub_comment10_55, d0_.sub_image10 AS sub_image10_56, d0_.sub_large_image10 AS sub_large_image10_57, d0_.papc3 AS papc3_58, d0_.papc4 AS papc4_59, d0_.papc7 AS papc7_60, d0_.papc11 AS papc11_61, d0_.papc12 AS papc12_62, d0_.papc13 AS papc13_63, d0_.papc14 AS papc14_64, d0_.papc15 AS papc15_65, d0_.papc16 AS papc16_66, d0_.papc18 AS papc18_67, d0_.artist_name AS artist_name_68, d0_.plg_deliveryfreeproduct AS plg_deliveryfreeproduct_69, d0_.shipping_name AS shipping_name_70, d0_.discriminator_type AS discriminator_type_71, d0_.creator_id AS creator_id_72, d0_.product_status_id AS product_status_id_73, d0_.papc2 AS papc2_74, d0_.schedule_time_id AS schedule_time_id_75 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') LEFT JOIN plg_schedule_time p4_ ON d0_.schedule_time_id = p4_.schedule_time_id INNER JOIN dtb_product_class d5_ ON d0_.id = d5_.product_id AND d5_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d2_.category_id IN (625) AND ((p4_.schedule_type IS NULL OR p4_.schedule_type = 1 AND ((p4_.time_from <= '2026-09-01 05:19:59' AND p4_.time_to > '2026-09-01 05:19:59') OR (p4_.time_from <= '2026-09-01 05:19:59' AND p4_.time_to IS NULL) OR (p4_.time_from IS NULL AND p4_.time_to > '2026-09-01 05:19:59') OR (p4_.time_from IS NULL AND p4_.time_to IS NULL) OR (p4_.view_flg = 1))) OR (p4_.schedule_type IS NULL OR p4_.schedule_type = 6 AND ((p4_.time_only_from <= '1419' AND p4_.time_only_to > '1419') OR (p4_.time_only_from <= '1419' AND p4_.time_only_to IS NULL) OR (p4_.time_only_from IS NULL AND p4_.time_only_to > '1419') OR (p4_.time_only_from IS NULL AND p4_.time_only_to IS NULL) OR (p4_.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 > '2026-09-01 05:19:59' OR p9_.time_to < '2026-09-01 05:19:59')) AND d7_.discriminator_type IN ('productcategory'))) AND d5_.sale_type_id <> 99 AND d0_.id IN (7664, 7663, 7579, 7552, 7551, 7547, 7546, 7544, 7216, 7199, 7198, 7197, 7193, 7185, 7167, 7145, 7131, 7128, 7127, 7126)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC;

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  dtb_product d0_
  INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id
  AND d1_.discriminator_type IN ('productclass')
  INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id
  AND d2_.discriminator_type IN ('productcategory')
  INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id
  AND d3_.discriminator_type IN ('category')
  LEFT JOIN plg_schedule_time p4_ ON d0_.schedule_time_id = p4_.schedule_time_id
  INNER JOIN dtb_product_class d5_ ON d0_.id = d5_.product_id
  AND d5_.discriminator_type IN ('productclass')
WHERE
  (
    d0_.product_status_id = 1
    AND d2_.category_id IN (?)
    AND (
      (
        p4_.schedule_type IS NULL
        OR p4_.schedule_type = ?
        AND (
          (
            p4_.time_from <= ?
            AND p4_.time_to > ?
          )
          OR (
            p4_.time_from <= ?
            AND p4_.time_to IS NULL
          )
          OR (
            p4_.time_from IS NULL
            AND p4_.time_to > ?
          )
          OR (
            p4_.time_from IS NULL
            AND p4_.time_to IS NULL
          )
          OR (p4_.view_flg = 1)
        )
      )
      OR (
        p4_.schedule_type IS NULL
        OR p4_.schedule_type = ?
        AND (
          (
            p4_.time_only_from <= ?
            AND p4_.time_only_to > ?
          )
          OR (
            p4_.time_only_from <= ?
            AND p4_.time_only_to IS NULL
          )
          OR (
            p4_.time_only_from IS NULL
            AND p4_.time_only_to > ?
          )
          OR (
            p4_.time_only_from IS NULL
            AND p4_.time_only_to IS NULL
          )
          OR (p4_.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 d5_.sale_type_id <> ?
  )
  AND d0_.discriminator_type IN ('product')

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') LEFT JOIN plg_schedule_time p4_ ON d0_.schedule_time_id = p4_.schedule_time_id INNER JOIN dtb_product_class d5_ ON d0_.id = d5_.product_id AND d5_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d2_.category_id IN (625) AND ((p4_.schedule_type IS NULL OR p4_.schedule_type = 1 AND ((p4_.time_from <= '2026-09-01 05:19:59' AND p4_.time_to > '2026-09-01 05:19:59') OR (p4_.time_from <= '2026-09-01 05:19:59' AND p4_.time_to IS NULL) OR (p4_.time_from IS NULL AND p4_.time_to > '2026-09-01 05:19:59') OR (p4_.time_from IS NULL AND p4_.time_to IS NULL) OR (p4_.view_flg = 1))) OR (p4_.schedule_type IS NULL OR p4_.schedule_type = 6 AND ((p4_.time_only_from <= '1419' AND p4_.time_only_to > '1419') OR (p4_.time_only_from <= '1419' AND p4_.time_only_to IS NULL) OR (p4_.time_only_from IS NULL AND p4_.time_only_to > '1419') OR (p4_.time_only_from IS NULL AND p4_.time_only_to IS NULL) OR (p4_.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 > '2026-09-01 05:19:59' OR p9_.time_to < '2026-09-01 05:19:59')) AND d7_.discriminator_type IN ('productcategory'))) AND d5_.sale_type_id <> 99) 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_
  INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id
  AND d1_.discriminator_type IN ('productclass')
  INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id
  AND d2_.discriminator_type IN ('productcategory')
  INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id
  AND d3_.discriminator_type IN ('category')
  LEFT JOIN plg_schedule_time p4_ ON d0_.schedule_time_id = p4_.schedule_time_id
  INNER JOIN dtb_product_class d5_ ON d0_.id = d5_.product_id
  AND d5_.discriminator_type IN ('productclass')
WHERE
  (
    d0_.product_status_id = 1
    AND d2_.category_id IN (?)
    AND (
      (
        p4_.schedule_type IS NULL
        OR p4_.schedule_type = ?
        AND (
          (
            p4_.time_from <= ?
            AND p4_.time_to > ?
          )
          OR (
            p4_.time_from <= ?
            AND p4_.time_to IS NULL
          )
          OR (
            p4_.time_from IS NULL
            AND p4_.time_to > ?
          )
          OR (
            p4_.time_from IS NULL
            AND p4_.time_to IS NULL
          )
          OR (p4_.view_flg = 1)
        )
      )
      OR (
        p4_.schedule_type IS NULL
        OR p4_.schedule_type = ?
        AND (
          (
            p4_.time_only_from <= ?
            AND p4_.time_only_to > ?
          )
          OR (
            p4_.time_only_from <= ?
            AND p4_.time_only_to IS NULL
          )
          OR (
            p4_.time_only_from IS NULL
            AND p4_.time_only_to > ?
          )
          OR (
            p4_.time_only_from IS NULL
            AND p4_.time_only_to IS NULL
          )
          OR (p4_.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 d5_.sale_type_id <> ?
  )
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d0_.create_date DESC,
  d0_.id DESC
LIMIT
  20

SELECT DISTINCT d0_.id AS id_0, d0_.create_date AS create_date_1, d0_.id AS id_2 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') LEFT JOIN plg_schedule_time p4_ ON d0_.schedule_time_id = p4_.schedule_time_id INNER JOIN dtb_product_class d5_ ON d0_.id = d5_.product_id AND d5_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d2_.category_id IN (625) AND ((p4_.schedule_type IS NULL OR p4_.schedule_type = 1 AND ((p4_.time_from <= '2026-09-01 05:19:59' AND p4_.time_to > '2026-09-01 05:19:59') OR (p4_.time_from <= '2026-09-01 05:19:59' AND p4_.time_to IS NULL) OR (p4_.time_from IS NULL AND p4_.time_to > '2026-09-01 05:19:59') OR (p4_.time_from IS NULL AND p4_.time_to IS NULL) OR (p4_.view_flg = 1))) OR (p4_.schedule_type IS NULL OR p4_.schedule_type = 6 AND ((p4_.time_only_from <= '1419' AND p4_.time_only_to > '1419') OR (p4_.time_only_from <= '1419' AND p4_.time_only_to IS NULL) OR (p4_.time_only_from IS NULL AND p4_.time_only_to > '1419') OR (p4_.time_only_from IS NULL AND p4_.time_only_to IS NULL) OR (p4_.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 > '2026-09-01 05:19:59' OR p9_.time_to < '2026-09-01 05:19:59')) AND d7_.discriminator_type IN ('productcategory'))) AND d5_.sale_type_id <> 99) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC LIMIT 20;

SELECT
  t0.product_id AS product_id_1,
  t0.status_id AS status_id_2,
  t0.product_id AS product_id_3,
  t0.status_id AS status_id_4,
  t0.discriminator_type
FROM
  dtb_product_status t0
WHERE
  t0.product_id = ?
  AND t0.discriminator_type IN ('productstatuscust')

SELECT t0.product_id AS product_id_1, t0.status_id AS status_id_2, t0.product_id AS product_id_3, t0.status_id AS status_id_4, t0.discriminator_type FROM dtb_product_status t0 WHERE t0.product_id = 7664 AND t0.discriminator_type IN ('productstatuscust');

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_artist t0
WHERE
  t0.product_id = ?
  AND t0.discriminator_type IN ('productcategoryartist')

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_artist t0 WHERE t0.product_id = 7664 AND t0.discriminator_type IN ('productcategoryartist');

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_.freeshipping_flg AS freeshipping_flg_9,
  d0_.comment1 AS comment1_10,
  d0_.comment2 AS comment2_11,
  d0_.comment3 AS comment3_12,
  d0_.comment4 AS comment4_13,
  d0_.comment5 AS comment5_14,
  d0_.comment6 AS comment6_15,
  d0_.main_list_comment AS main_list_comment_16,
  d0_.main_comment AS main_comment_17,
  d0_.sub_title1 AS sub_title1_18,
  d0_.sub_comment1 AS sub_comment1_19,
  d0_.sub_image1 AS sub_image1_20,
  d0_.sub_large_image1 AS sub_large_image1_21,
  d0_.sub_title2 AS sub_title2_22,
  d0_.sub_comment2 AS sub_comment2_23,
  d0_.sub_image2 AS sub_image2_24,
  d0_.sub_large_image2 AS sub_large_image2_25,
  d0_.sub_title3 AS sub_title3_26,
  d0_.sub_comment3 AS sub_comment3_27,
  d0_.sub_image3 AS sub_image3_28,
  d0_.sub_large_image3 AS sub_large_image3_29,
  d0_.sub_title4 AS sub_title4_30,
  d0_.sub_comment4 AS sub_comment4_31,
  d0_.sub_image4 AS sub_image4_32,
  d0_.sub_large_image4 AS sub_large_image4_33,
  d0_.sub_title5 AS sub_title5_34,
  d0_.sub_comment5 AS sub_comment5_35,
  d0_.sub_image5 AS sub_image5_36,
  d0_.sub_large_image5 AS sub_large_image5_37,
  d0_.sub_title6 AS sub_title6_38,
  d0_.sub_comment6 AS sub_comment6_39,
  d0_.sub_image6 AS sub_image6_40,
  d0_.sub_large_image6 AS sub_large_image6_41,
  d0_.sub_title7 AS sub_title7_42,
  d0_.sub_comment7 AS sub_comment7_43,
  d0_.sub_image7 AS sub_image7_44,
  d0_.sub_large_image7 AS sub_large_image7_45,
  d0_.sub_title8 AS sub_title8_46,
  d0_.sub_comment8 AS sub_comment8_47,
  d0_.sub_image8 AS sub_image8_48,
  d0_.sub_large_image8 AS sub_large_image8_49,
  d0_.sub_title9 AS sub_title9_50,
  d0_.sub_comment9 AS sub_comment9_51,
  d0_.sub_image9 AS sub_image9_52,
  d0_.sub_large_image9 AS sub_large_image9_53,
  d0_.sub_title10 AS sub_title10_54,
  d0_.sub_comment10 AS sub_comment10_55,
  d0_.sub_image10 AS sub_image10_56,
  d0_.sub_large_image10 AS sub_large_image10_57,
  d0_.papc3 AS papc3_58,
  d0_.papc4 AS papc4_59,
  d0_.papc7 AS papc7_60,
  d0_.papc11 AS papc11_61,
  d0_.papc12 AS papc12_62,
  d0_.papc13 AS papc13_63,
  d0_.papc14 AS papc14_64,
  d0_.papc15 AS papc15_65,
  d0_.papc16 AS papc16_66,
  d0_.papc18 AS papc18_67,
  d0_.artist_name AS artist_name_68,
  d0_.plg_deliveryfreeproduct AS plg_deliveryfreeproduct_69,
  d0_.shipping_name AS shipping_name_70,
  d1_.id AS id_71,
  d1_.product_code AS product_code_72,
  d1_.stock AS stock_73,
  d1_.stock_unlimited AS stock_unlimited_74,
  d1_.sale_limit AS sale_limit_75,
  d1_.price01 AS price01_76,
  d1_.price02 AS price02_77,
  d1_.delivery_fee AS delivery_fee_78,
  d1_.visible AS visible_79,
  d1_.create_date AS create_date_80,
  d1_.update_date AS update_date_81,
  d1_.currency_code AS currency_code_82,
  d1_.point_rate AS point_rate_83,
  d1_.sale_type AS sale_type_84,
  d1_.sale_price AS sale_price_85,
  d1_.original_price01 AS original_price01_86,
  d1_.original_price02 AS original_price02_87,
  d1_.deliv_fee AS deliv_fee_88,
  d2_.id AS id_89,
  d2_.tax_rate AS tax_rate_90,
  d2_.tax_adjust AS tax_adjust_91,
  d2_.apply_date AS apply_date_92,
  d2_.create_date AS create_date_93,
  d2_.update_date AS update_date_94,
  d3_.id AS id_95,
  d3_.stock AS stock_96,
  d3_.create_date AS create_date_97,
  d3_.update_date AS update_date_98,
  d4_.id AS id_99,
  d4_.backend_name AS backend_name_100,
  d4_.name AS name_101,
  d4_.sort_no AS sort_no_102,
  d4_.visible AS visible_103,
  d4_.create_date AS create_date_104,
  d4_.update_date AS update_date_105,
  d5_.id AS id_106,
  d5_.backend_name AS backend_name_107,
  d5_.name AS name_108,
  d5_.sort_no AS sort_no_109,
  d5_.visible AS visible_110,
  d5_.create_date AS create_date_111,
  d5_.update_date AS update_date_112,
  d6_.id AS id_113,
  d6_.file_name AS file_name_114,
  d6_.sort_no AS sort_no_115,
  d6_.create_date AS create_date_116,
  d7_.id AS id_117,
  d7_.create_date AS create_date_118,
  d0_.discriminator_type AS discriminator_type_119,
  d0_.creator_id AS creator_id_120,
  d0_.product_status_id AS product_status_id_121,
  d0_.papc2 AS papc2_122,
  d0_.schedule_time_id AS schedule_time_id_123,
  d1_.discriminator_type AS discriminator_type_124,
  d1_.product_id AS product_id_125,
  d1_.sale_type_id AS sale_type_id_126,
  d1_.class_category_id1 AS class_category_id1_127,
  d1_.class_category_id2 AS class_category_id2_128,
  d1_.delivery_duration_id AS delivery_duration_id_129,
  d1_.creator_id AS creator_id_130,
  d2_.discriminator_type AS discriminator_type_131,
  d2_.product_class_id AS product_class_id_132,
  d2_.creator_id AS creator_id_133,
  d2_.country_id AS country_id_134,
  d2_.pref_id AS pref_id_135,
  d2_.product_id AS product_id_136,
  d2_.rounding_type_id AS rounding_type_id_137,
  d3_.discriminator_type AS discriminator_type_138,
  d3_.product_class_id AS product_class_id_139,
  d3_.creator_id AS creator_id_140,
  d4_.discriminator_type AS discriminator_type_141,
  d4_.class_name_id AS class_name_id_142,
  d4_.creator_id AS creator_id_143,
  d5_.discriminator_type AS discriminator_type_144,
  d5_.class_name_id AS class_name_id_145,
  d5_.creator_id AS creator_id_146,
  d6_.discriminator_type AS discriminator_type_147,
  d6_.product_id AS product_id_148,
  d6_.creator_id AS creator_id_149,
  d7_.discriminator_type AS discriminator_type_150,
  d7_.product_id AS product_id_151,
  d7_.tag_id AS tag_id_152,
  d7_.creator_id AS creator_id_153
FROM
  dtb_product d0_
  INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id
  AND d1_.discriminator_type IN ('productclass')
  LEFT JOIN dtb_tax_rule d2_ ON d1_.id = d2_.product_class_id
  AND d2_.discriminator_type IN ('taxrule')
  INNER JOIN dtb_product_stock d3_ ON d1_.id = d3_.product_class_id
  AND d3_.discriminator_type IN ('productstock')
  LEFT JOIN dtb_class_category d4_ ON d1_.class_category_id1 = d4_.id
  AND d4_.discriminator_type IN ('classcategory')
  LEFT JOIN dtb_class_category d5_ ON d1_.class_category_id2 = d5_.id
  AND d5_.discriminator_type IN ('classcategory')
  LEFT JOIN dtb_product_image d6_ ON d0_.id = d6_.product_id
  AND d6_.discriminator_type IN ('productimage')
  LEFT JOIN dtb_product_tag d7_ ON d0_.id = d7_.product_id
  AND d7_.discriminator_type IN ('producttag')
WHERE
  (
    d0_.id IN (
      7664, 7663, 7579, 7552, 7551, 7547, 7546,
      7544, 7216, 7199, 7198, 7197, 7193,
      7185, 7167, 7145, 7131, 7128, 7127,
      7126
    )
    AND d1_.visible = ?
  )
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d4_.sort_no DESC,
  d5_.sort_no DESC,
  d6_.sort_no ASC

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_.freeshipping_flg AS freeshipping_flg_9, d0_.comment1 AS comment1_10, d0_.comment2 AS comment2_11, d0_.comment3 AS comment3_12, d0_.comment4 AS comment4_13, d0_.comment5 AS comment5_14, d0_.comment6 AS comment6_15, d0_.main_list_comment AS main_list_comment_16, d0_.main_comment AS main_comment_17, d0_.sub_title1 AS sub_title1_18, d0_.sub_comment1 AS sub_comment1_19, d0_.sub_image1 AS sub_image1_20, d0_.sub_large_image1 AS sub_large_image1_21, d0_.sub_title2 AS sub_title2_22, d0_.sub_comment2 AS sub_comment2_23, d0_.sub_image2 AS sub_image2_24, d0_.sub_large_image2 AS sub_large_image2_25, d0_.sub_title3 AS sub_title3_26, d0_.sub_comment3 AS sub_comment3_27, d0_.sub_image3 AS sub_image3_28, d0_.sub_large_image3 AS sub_large_image3_29, d0_.sub_title4 AS sub_title4_30, d0_.sub_comment4 AS sub_comment4_31, d0_.sub_image4 AS sub_image4_32, d0_.sub_large_image4 AS sub_large_image4_33, d0_.sub_title5 AS sub_title5_34, d0_.sub_comment5 AS sub_comment5_35, d0_.sub_image5 AS sub_image5_36, d0_.sub_large_image5 AS sub_large_image5_37, d0_.sub_title6 AS sub_title6_38, d0_.sub_comment6 AS sub_comment6_39, d0_.sub_image6 AS sub_image6_40, d0_.sub_large_image6 AS sub_large_image6_41, d0_.sub_title7 AS sub_title7_42, d0_.sub_comment7 AS sub_comment7_43, d0_.sub_image7 AS sub_image7_44, d0_.sub_large_image7 AS sub_large_image7_45, d0_.sub_title8 AS sub_title8_46, d0_.sub_comment8 AS sub_comment8_47, d0_.sub_image8 AS sub_image8_48, d0_.sub_large_image8 AS sub_large_image8_49, d0_.sub_title9 AS sub_title9_50, d0_.sub_comment9 AS sub_comment9_51, d0_.sub_image9 AS sub_image9_52, d0_.sub_large_image9 AS sub_large_image9_53, d0_.sub_title10 AS sub_title10_54, d0_.sub_comment10 AS sub_comment10_55, d0_.sub_image10 AS sub_image10_56, d0_.sub_large_image10 AS sub_large_image10_57, d0_.papc3 AS papc3_58, d0_.papc4 AS papc4_59, d0_.papc7 AS papc7_60, d0_.papc11 AS papc11_61, d0_.papc12 AS papc12_62, d0_.papc13 AS papc13_63, d0_.papc14 AS papc14_64, d0_.papc15 AS papc15_65, d0_.papc16 AS papc16_66, d0_.papc18 AS papc18_67, d0_.artist_name AS artist_name_68, d0_.plg_deliveryfreeproduct AS plg_deliveryfreeproduct_69, d0_.shipping_name AS shipping_name_70, d1_.id AS id_71, d1_.product_code AS product_code_72, d1_.stock AS stock_73, d1_.stock_unlimited AS stock_unlimited_74, d1_.sale_limit AS sale_limit_75, d1_.price01 AS price01_76, d1_.price02 AS price02_77, d1_.delivery_fee AS delivery_fee_78, d1_.visible AS visible_79, d1_.create_date AS create_date_80, d1_.update_date AS update_date_81, d1_.currency_code AS currency_code_82, d1_.point_rate AS point_rate_83, d1_.sale_type AS sale_type_84, d1_.sale_price AS sale_price_85, d1_.original_price01 AS original_price01_86, d1_.original_price02 AS original_price02_87, d1_.deliv_fee AS deliv_fee_88, d2_.id AS id_89, d2_.tax_rate AS tax_rate_90, d2_.tax_adjust AS tax_adjust_91, d2_.apply_date AS apply_date_92, d2_.create_date AS create_date_93, d2_.update_date AS update_date_94, d3_.id AS id_95, d3_.stock AS stock_96, d3_.create_date AS create_date_97, d3_.update_date AS update_date_98, d4_.id AS id_99, d4_.backend_name AS backend_name_100, d4_.name AS name_101, d4_.sort_no AS sort_no_102, d4_.visible AS visible_103, d4_.create_date AS create_date_104, d4_.update_date AS update_date_105, d5_.id AS id_106, d5_.backend_name AS backend_name_107, d5_.name AS name_108, d5_.sort_no AS sort_no_109, d5_.visible AS visible_110, d5_.create_date AS create_date_111, d5_.update_date AS update_date_112, d6_.id AS id_113, d6_.file_name AS file_name_114, d6_.sort_no AS sort_no_115, d6_.create_date AS create_date_116, d7_.id AS id_117, d7_.create_date AS create_date_118, d0_.discriminator_type AS discriminator_type_119, d0_.creator_id AS creator_id_120, d0_.product_status_id AS product_status_id_121, d0_.papc2 AS papc2_122, d0_.schedule_time_id AS schedule_time_id_123, d1_.discriminator_type AS discriminator_type_124, d1_.product_id AS product_id_125, d1_.sale_type_id AS sale_type_id_126, d1_.class_category_id1 AS class_category_id1_127, d1_.class_category_id2 AS class_category_id2_128, d1_.delivery_duration_id AS delivery_duration_id_129, d1_.creator_id AS creator_id_130, d2_.discriminator_type AS discriminator_type_131, d2_.product_class_id AS product_class_id_132, d2_.creator_id AS creator_id_133, d2_.country_id AS country_id_134, d2_.pref_id AS pref_id_135, d2_.product_id AS product_id_136, d2_.rounding_type_id AS rounding_type_id_137, d3_.discriminator_type AS discriminator_type_138, d3_.product_class_id AS product_class_id_139, d3_.creator_id AS creator_id_140, d4_.discriminator_type AS discriminator_type_141, d4_.class_name_id AS class_name_id_142, d4_.creator_id AS creator_id_143, d5_.discriminator_type AS discriminator_type_144, d5_.class_name_id AS class_name_id_145, d5_.creator_id AS creator_id_146, d6_.discriminator_type AS discriminator_type_147, d6_.product_id AS product_id_148, d6_.creator_id AS creator_id_149, d7_.discriminator_type AS discriminator_type_150, d7_.product_id AS product_id_151, d7_.tag_id AS tag_id_152, d7_.creator_id AS creator_id_153 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_tax_rule d2_ ON d1_.id = d2_.product_class_id AND d2_.discriminator_type IN ('taxrule') INNER JOIN dtb_product_stock d3_ ON d1_.id = d3_.product_class_id AND d3_.discriminator_type IN ('productstock') LEFT JOIN dtb_class_category d4_ ON d1_.class_category_id1 = d4_.id AND d4_.discriminator_type IN ('classcategory') LEFT JOIN dtb_class_category d5_ ON d1_.class_category_id2 = d5_.id AND d5_.discriminator_type IN ('classcategory') LEFT JOIN dtb_product_image d6_ ON d0_.id = d6_.product_id AND d6_.discriminator_type IN ('productimage') LEFT JOIN dtb_product_tag d7_ ON d0_.id = d7_.product_id AND d7_.discriminator_type IN ('producttag') WHERE (d0_.id IN (7664, 7663, 7579, 7552, 7551, 7547, 7546, 7544, 7216, 7199, 7198, 7197, 7193, 7185, 7167, 7145, 7131, 7128, 7127, 7126) AND d1_.visible = 1) AND d0_.discriminator_type IN ('product') ORDER BY d4_.sort_no DESC, d5_.sort_no DESC, d6_.sort_no ASC;