Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.publish_date AS publish_date_1,
  d0_.title AS title_2,
  d0_.description AS description_3,
  d0_.url AS url_4,
  d0_.link_method AS link_method_5,
  d0_.create_date AS create_date_6,
  d0_.update_date AS update_date_7,
  d0_.visible AS visible_8,
  d0_.end_date AS end_date_9,
  d0_.sort_no AS sort_no_10,
  d0_.discriminator_type AS discriminator_type_11,
  d0_.creator_id AS creator_id_12,
  d0_.category_id AS category_id_13,
  d0_.type_id AS type_id_14
FROM
  dtb_news d0_
WHERE
  (
    d0_.category_id = ?
    AND d0_.visible = 1
  )
  AND d0_.discriminator_type IN ('news')
ORDER BY
  d0_.publish_date DESC

SELECT d0_.id AS id_0, d0_.publish_date AS publish_date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.url AS url_4, d0_.link_method AS link_method_5, d0_.create_date AS create_date_6, d0_.update_date AS update_date_7, d0_.visible AS visible_8, d0_.end_date AS end_date_9, d0_.sort_no AS sort_no_10, d0_.discriminator_type AS discriminator_type_11, d0_.creator_id AS creator_id_12, d0_.category_id AS category_id_13, d0_.type_id AS type_id_14 FROM dtb_news d0_ WHERE (d0_.category_id = 1 AND d0_.visible = 1) AND d0_.discriminator_type IN ('news') ORDER BY d0_.publish_date 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.parent_category_id AS parent_category_id_7,
  t0.creator_id AS creator_id_8,
  t0.schedule_time_id AS schedule_time_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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.schedule_time_id AS schedule_time_id_9, t0.discriminator_type FROM dtb_category t0 WHERE t0.parent_category_id = 1 AND t0.discriminator_type IN ('category') ORDER BY t0.sort_no DESC;

SELECT
  DISTINCT 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')
  INNER JOIN dtb_product_status d4_ ON d0_.id = d4_.product_id
  AND d4_.discriminator_type IN ('productstatuscust')
WHERE
  (
    d0_.product_status_id = 1
    AND d2_.category_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
    AND d1_.sale_type_id = ?
    AND d4_.status_id = ?
    AND (
      d1_.stock_unlimited = 1
      OR d1_.stock > 0
    )
  )
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d0_.create_date DESC,
  d0_.id DESC
LIMIT
  8

SELECT DISTINCT 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') INNER JOIN dtb_product_status d4_ ON d0_.id = d4_.product_id AND d4_.discriminator_type IN ('productstatuscust') WHERE (d0_.product_status_id = 1 AND d2_.category_id IN (1, 638, 637, 636, 635, 634, 633, 632, 631, 630, 629, 628, 627, 626, 625, 624, 621, 619, 617, 616, 613, 104, 103, 102, 612, 101, 100, 609) AND d1_.sale_type_id = 99 AND d4_.status_id = 5 AND (d1_.stock_unlimited = 1 OR d1_.stock > 0)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC LIMIT 8;

SELECT
  DISTINCT 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')
  INNER JOIN dtb_product_status d4_ ON d0_.id = d4_.product_id
  AND d4_.discriminator_type IN ('productstatuscust')
WHERE
  (
    d0_.product_status_id = 1
    AND d2_.category_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
    AND d1_.sale_type_id = ?
    AND d4_.status_id = ?
    AND (
      d1_.stock_unlimited = 1
      OR d1_.stock > 0
    )
  )
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d0_.create_date DESC,
  d0_.id DESC
LIMIT
  4

SELECT DISTINCT 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') INNER JOIN dtb_product_status d4_ ON d0_.id = d4_.product_id AND d4_.discriminator_type IN ('productstatuscust') WHERE (d0_.product_status_id = 1 AND d2_.category_id IN (1, 638, 637, 636, 635, 634, 633, 632, 631, 630, 629, 628, 627, 626, 625, 624, 621, 619, 617, 616, 613, 104, 103, 102, 612, 101, 100, 609) AND d1_.sale_type_id = 99 AND d4_.status_id = 1 AND (d1_.stock_unlimited = 1 OR d1_.stock > 0)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC LIMIT 4;

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,
  d1_.id AS id_6,
  d1_.category_name AS category_name_7,
  d1_.hierarchy AS hierarchy_8,
  d1_.sort_no AS sort_no_9,
  d1_.create_date AS create_date_10,
  d1_.update_date AS update_date_11,
  d2_.id AS id_12,
  d2_.category_name AS category_name_13,
  d2_.hierarchy AS hierarchy_14,
  d2_.sort_no AS sort_no_15,
  d2_.create_date AS create_date_16,
  d2_.update_date AS update_date_17,
  d3_.id AS id_18,
  d3_.category_name AS category_name_19,
  d3_.hierarchy AS hierarchy_20,
  d3_.sort_no AS sort_no_21,
  d3_.create_date AS create_date_22,
  d3_.update_date AS update_date_23,
  d4_.id AS id_24,
  d4_.category_name AS category_name_25,
  d4_.hierarchy AS hierarchy_26,
  d4_.sort_no AS sort_no_27,
  d4_.create_date AS create_date_28,
  d4_.update_date AS update_date_29,
  d0_.discriminator_type AS discriminator_type_30,
  d0_.parent_category_id AS parent_category_id_31,
  d0_.creator_id AS creator_id_32,
  d0_.schedule_time_id AS schedule_time_id_33,
  d1_.discriminator_type AS discriminator_type_34,
  d1_.parent_category_id AS parent_category_id_35,
  d1_.creator_id AS creator_id_36,
  d1_.schedule_time_id AS schedule_time_id_37,
  d2_.discriminator_type AS discriminator_type_38,
  d2_.parent_category_id AS parent_category_id_39,
  d2_.creator_id AS creator_id_40,
  d2_.schedule_time_id AS schedule_time_id_41,
  d3_.discriminator_type AS discriminator_type_42,
  d3_.parent_category_id AS parent_category_id_43,
  d3_.creator_id AS creator_id_44,
  d3_.schedule_time_id AS schedule_time_id_45,
  d4_.discriminator_type AS discriminator_type_46,
  d4_.parent_category_id AS parent_category_id_47,
  d4_.creator_id AS creator_id_48,
  d4_.schedule_time_id AS schedule_time_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, d1_.id AS id_6, d1_.category_name AS category_name_7, d1_.hierarchy AS hierarchy_8, d1_.sort_no AS sort_no_9, d1_.create_date AS create_date_10, d1_.update_date AS update_date_11, d2_.id AS id_12, d2_.category_name AS category_name_13, d2_.hierarchy AS hierarchy_14, d2_.sort_no AS sort_no_15, d2_.create_date AS create_date_16, d2_.update_date AS update_date_17, d3_.id AS id_18, d3_.category_name AS category_name_19, d3_.hierarchy AS hierarchy_20, d3_.sort_no AS sort_no_21, d3_.create_date AS create_date_22, d3_.update_date AS update_date_23, d4_.id AS id_24, d4_.category_name AS category_name_25, d4_.hierarchy AS hierarchy_26, d4_.sort_no AS sort_no_27, d4_.create_date AS create_date_28, d4_.update_date AS update_date_29, d0_.discriminator_type AS discriminator_type_30, d0_.parent_category_id AS parent_category_id_31, d0_.creator_id AS creator_id_32, d0_.schedule_time_id AS schedule_time_id_33, d1_.discriminator_type AS discriminator_type_34, d1_.parent_category_id AS parent_category_id_35, d1_.creator_id AS creator_id_36, d1_.schedule_time_id AS schedule_time_id_37, d2_.discriminator_type AS discriminator_type_38, d2_.parent_category_id AS parent_category_id_39, d2_.creator_id AS creator_id_40, d2_.schedule_time_id AS schedule_time_id_41, d3_.discriminator_type AS discriminator_type_42, d3_.parent_category_id AS parent_category_id_43, d3_.creator_id AS creator_id_44, d3_.schedule_time_id AS schedule_time_id_45, d4_.discriminator_type AS discriminator_type_46, d4_.parent_category_id AS parent_category_id_47, d4_.creator_id AS creator_id_48, d4_.schedule_time_id AS schedule_time_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.id AS id_1,
  t0.name01 AS name01_2,
  t0.name02 AS name02_3,
  t0.kana01 AS kana01_4,
  t0.kana02 AS kana02_5,
  t0.company_name AS company_name_6,
  t0.postal_code AS postal_code_7,
  t0.addr01 AS addr01_8,
  t0.addr02 AS addr02_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.birth AS birth_12,
  t0.password AS password_13,
  t0.salt AS salt_14,
  t0.secret_key AS secret_key_15,
  t0.first_buy_date AS first_buy_date_16,
  t0.last_buy_date AS last_buy_date_17,
  t0.buy_times AS buy_times_18,
  t0.buy_total AS buy_total_19,
  t0.note AS note_20,
  t0.reset_key AS reset_key_21,
  t0.reset_expire AS reset_expire_22,
  t0.point AS point_23,
  t0.create_date AS create_date_24,
  t0.update_date AS update_date_25,
  t0.tel01 AS tel01_26,
  t0.tel02 AS tel02_27,
  t0.tel03 AS tel03_28,
  t0.address_type AS address_type_29,
  t0.plg_mailmagazine_flg AS plg_mailmagazine_flg_30,
  t0.paygent_card_stock AS paygent_card_stock_31,
  t0.atone_module_authentication_token AS atone_module_authentication_token_32,
  t0.customer_status_id AS customer_status_id_33,
  t0.sex_id AS sex_id_34,
  t0.job_id AS job_id_35,
  t0.country_id AS country_id_36,
  t0.pref_id AS pref_id_37,
  t0.black_status_id AS black_status_id_38,
  t0.discriminator_type
FROM
  dtb_customer t0
WHERE
  t0.email = ?
  AND t0.customer_status_id = ?
  AND t0.discriminator_type IN ('customer')
LIMIT
  1

SELECT t0.id AS id_1, t0.name01 AS name01_2, t0.name02 AS name02_3, t0.kana01 AS kana01_4, t0.kana02 AS kana02_5, t0.company_name AS company_name_6, t0.postal_code AS postal_code_7, t0.addr01 AS addr01_8, t0.addr02 AS addr02_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.birth AS birth_12, t0.password AS password_13, t0.salt AS salt_14, t0.secret_key AS secret_key_15, t0.first_buy_date AS first_buy_date_16, t0.last_buy_date AS last_buy_date_17, t0.buy_times AS buy_times_18, t0.buy_total AS buy_total_19, t0.note AS note_20, t0.reset_key AS reset_key_21, t0.reset_expire AS reset_expire_22, t0.point AS point_23, t0.create_date AS create_date_24, t0.update_date AS update_date_25, t0.tel01 AS tel01_26, t0.tel02 AS tel02_27, t0.tel03 AS tel03_28, t0.address_type AS address_type_29, t0.plg_mailmagazine_flg AS plg_mailmagazine_flg_30, t0.paygent_card_stock AS paygent_card_stock_31, t0.atone_module_authentication_token AS atone_module_authentication_token_32, t0.customer_status_id AS customer_status_id_33, t0.sex_id AS sex_id_34, t0.job_id AS job_id_35, t0.country_id AS country_id_36, t0.pref_id AS pref_id_37, t0.black_status_id AS black_status_id_38, t0.discriminator_type FROM dtb_customer t0 WHERE t0.email = 'm-obata@wardrecords.com' AND t0.customer_status_id = 2 AND t0.discriminator_type IN ('customer') LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.layout_name AS layout_name_1,
  d0_.create_date AS create_date_2,
  d0_.update_date AS update_date_3,
  d1_.section AS section_4,
  d1_.block_id AS block_id_5,
  d1_.layout_id AS layout_id_6,
  d1_.block_row AS block_row_7,
  d2_.id AS id_8,
  d2_.block_name AS block_name_9,
  d2_.file_name AS file_name_10,
  d2_.use_controller AS use_controller_11,
  d2_.deletable AS deletable_12,
  d2_.create_date AS create_date_13,
  d2_.update_date AS update_date_14,
  d0_.discriminator_type AS discriminator_type_15,
  d0_.device_type_id AS device_type_id_16,
  d1_.discriminator_type AS discriminator_type_17,
  d1_.block_id AS block_id_18,
  d1_.layout_id AS layout_id_19,
  d2_.discriminator_type AS discriminator_type_20,
  d2_.device_type_id AS device_type_id_21,
  d2_.schedule_time_id AS schedule_time_id_22
FROM
  dtb_layout d0_
  LEFT JOIN dtb_block_position d1_ ON d0_.id = d1_.layout_id
  AND d1_.discriminator_type IN ('blockposition')
  LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.id
  AND d2_.discriminator_type IN ('block')
WHERE
  (d0_.id = ?)
  AND d0_.discriminator_type IN ('layout')
ORDER BY
  d1_.block_row ASC

SELECT d0_.id AS id_0, d0_.layout_name AS layout_name_1, d0_.create_date AS create_date_2, d0_.update_date AS update_date_3, d1_.section AS section_4, d1_.block_id AS block_id_5, d1_.layout_id AS layout_id_6, d1_.block_row AS block_row_7, d2_.id AS id_8, d2_.block_name AS block_name_9, d2_.file_name AS file_name_10, d2_.use_controller AS use_controller_11, d2_.deletable AS deletable_12, d2_.create_date AS create_date_13, d2_.update_date AS update_date_14, d0_.discriminator_type AS discriminator_type_15, d0_.device_type_id AS device_type_id_16, d1_.discriminator_type AS discriminator_type_17, d1_.block_id AS block_id_18, d1_.layout_id AS layout_id_19, d2_.discriminator_type AS discriminator_type_20, d2_.device_type_id AS device_type_id_21, d2_.schedule_time_id AS schedule_time_id_22 FROM dtb_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.id = d1_.layout_id AND d1_.discriminator_type IN ('blockposition') LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.id AND d2_.discriminator_type IN ('block') WHERE (d0_.id = 2) AND d0_.discriminator_type IN ('layout') ORDER BY d1_.block_row ASC;

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.company_kana AS company_kana_3,
  t0.postal_code AS postal_code_4,
  t0.addr01 AS addr01_5,
  t0.addr02 AS addr02_6,
  t0.phone_number AS phone_number_7,
  t0.business_hour AS business_hour_8,
  t0.email01 AS email01_9,
  t0.email02 AS email02_10,
  t0.email03 AS email03_11,
  t0.email04 AS email04_12,
  t0.shop_name AS shop_name_13,
  t0.shop_kana AS shop_kana_14,
  t0.shop_name_eng AS shop_name_eng_15,
  t0.update_date AS update_date_16,
  t0.good_traded AS good_traded_17,
  t0.message AS message_18,
  t0.delivery_free_amount AS delivery_free_amount_19,
  t0.delivery_free_quantity AS delivery_free_quantity_20,
  t0.option_mypage_order_status_display AS option_mypage_order_status_display_21,
  t0.option_nostock_hidden AS option_nostock_hidden_22,
  t0.option_favorite_product AS option_favorite_product_23,
  t0.option_product_delivery_fee AS option_product_delivery_fee_24,
  t0.invoice_registration_number AS invoice_registration_number_25,
  t0.option_product_tax_rule AS option_product_tax_rule_26,
  t0.option_customer_activate AS option_customer_activate_27,
  t0.option_remember_me AS option_remember_me_28,
  t0.option_mail_notifier AS option_mail_notifier_29,
  t0.authentication_key AS authentication_key_30,
  t0.php_path AS php_path_31,
  t0.option_point AS option_point_32,
  t0.basic_point_rate AS basic_point_rate_33,
  t0.point_conversion_rate AS point_conversion_rate_34,
  t0.country_id AS country_id_35,
  t0.pref_id AS pref_id_36,
  t0.discriminator_type
FROM
  dtb_base_info t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('baseinfo')

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('baseinfo');