Symfony Profiler

SET SESSION time_zone = '+00:00'

[]

SET
  SESSION time_zone = '+00:00'

SET SESSION time_zone = '+00:00';

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')

[
  1
]

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');

SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = ?) AND d0_.discriminator_type IN ('page')

[
  "search_list"
]

SELECT
  d0_.id AS id_0,
  d0_.page_name AS page_name_1,
  d0_.url AS url_2,
  d0_.file_name AS file_name_3,
  d0_.edit_type AS edit_type_4,
  d0_.author AS author_5,
  d0_.description AS description_6,
  d0_.keyword AS keyword_7,
  d0_.create_date AS create_date_8,
  d0_.update_date AS update_date_9,
  d0_.meta_robots AS meta_robots_10,
  d0_.meta_tags AS meta_tags_11,
  d1_.page_id AS page_id_12,
  d1_.layout_id AS layout_id_13,
  d1_.sort_no AS sort_no_14,
  d2_.id AS id_15,
  d2_.layout_name AS layout_name_16,
  d2_.create_date AS create_date_17,
  d2_.update_date AS update_date_18,
  d0_.discriminator_type AS discriminator_type_19,
  d0_.master_page_id AS master_page_id_20,
  d1_.discriminator_type AS discriminator_type_21,
  d1_.page_id AS page_id_22,
  d1_.layout_id AS layout_id_23,
  d2_.discriminator_type AS discriminator_type_24,
  d2_.device_type_id AS device_type_id_25
FROM
  dtb_page d0_
  LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id
  AND d1_.discriminator_type IN ('pagelayout')
  LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id
  AND d2_.discriminator_type IN ('layout')
WHERE
  (d0_.url = ?)
  AND d0_.discriminator_type IN ('page')

SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = 'search_list') AND d0_.discriminator_type IN ('page');

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED

[]

SET
  SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

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.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') LIMIT 1

[
  1
]

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.url AS url_7,
  t0.title_image_path AS title_image_path_8,
  t0.teikikoudoku1 AS teikikoudoku1_9,
  t0.teikikoudoku2 AS teikikoudoku2_10,
  t0.menuno AS menuno_11,
  t0.kankou AS kankou_12,
  t0.hatsubaibi AS hatsubaibi_13,
  t0.newno AS newno_14,
  t0.linkimage01 AS linkimage01_15,
  t0.linkimage02 AS linkimage02_16,
  t0.linkimage03 AS linkimage03_17,
  t0.linkimage04 AS linkimage04_18,
  t0.linkimage05 AS linkimage05_19,
  t0.linkimage06 AS linkimage06_20,
  t0.linkimage07 AS linkimage07_21,
  t0.linkimage08 AS linkimage08_22,
  t0.linkimage09 AS linkimage09_23,
  t0.linkimage10 AS linkimage10_24,
  t0.linkimage11 AS linkimage11_25,
  t0.linkimage12 AS linkimage12_26,
  t0.linkimage13 AS linkimage13_27,
  t0.linkimage14 AS linkimage14_28,
  t0.linkimage15 AS linkimage15_29,
  t0.linkimage16 AS linkimage16_30,
  t0.linkimage17 AS linkimage17_31,
  t0.linkimage18 AS linkimage18_32,
  t0.linkimage19 AS linkimage19_33,
  t0.linkimage20 AS linkimage20_34,
  t0.linkimage21 AS linkimage21_35,
  t0.linkimage22 AS linkimage22_36,
  t0.linkimage23 AS linkimage23_37,
  t0.linkimage24 AS linkimage24_38,
  t0.linkimage25 AS linkimage25_39,
  t0.linkimage26 AS linkimage26_40,
  t0.linkimage27 AS linkimage27_41,
  t0.linkimage28 AS linkimage28_42,
  t0.linkimage29 AS linkimage29_43,
  t0.linkimage30 AS linkimage30_44,
  t0.link01 AS link01_45,
  t0.link02 AS link02_46,
  t0.link03 AS link03_47,
  t0.link04 AS link04_48,
  t0.link05 AS link05_49,
  t0.link06 AS link06_50,
  t0.link07 AS link07_51,
  t0.link08 AS link08_52,
  t0.link09 AS link09_53,
  t0.link10 AS link10_54,
  t0.link11 AS link11_55,
  t0.link12 AS link12_56,
  t0.link13 AS link13_57,
  t0.link14 AS link14_58,
  t0.link15 AS link15_59,
  t0.link16 AS link16_60,
  t0.link17 AS link17_61,
  t0.link18 AS link18_62,
  t0.link19 AS link19_63,
  t0.link20 AS link20_64,
  t0.link21 AS link21_65,
  t0.link22 AS link22_66,
  t0.link23 AS link23_67,
  t0.link24 AS link24_68,
  t0.link25 AS link25_69,
  t0.link26 AS link26_70,
  t0.link27 AS link27_71,
  t0.link28 AS link28_72,
  t0.link29 AS link29_73,
  t0.link30 AS link30_74,
  t0.blank01 AS blank01_75,
  t0.blank02 AS blank02_76,
  t0.blank03 AS blank03_77,
  t0.blank04 AS blank04_78,
  t0.blank05 AS blank05_79,
  t0.blank06 AS blank06_80,
  t0.blank07 AS blank07_81,
  t0.blank08 AS blank08_82,
  t0.blank09 AS blank09_83,
  t0.blank10 AS blank10_84,
  t0.blank11 AS blank11_85,
  t0.blank12 AS blank12_86,
  t0.blank13 AS blank13_87,
  t0.blank14 AS blank14_88,
  t0.blank15 AS blank15_89,
  t0.blank16 AS blank16_90,
  t0.blank17 AS blank17_91,
  t0.blank18 AS blank18_92,
  t0.blank19 AS blank19_93,
  t0.blank20 AS blank20_94,
  t0.blank21 AS blank21_95,
  t0.blank22 AS blank22_96,
  t0.blank23 AS blank23_97,
  t0.blank24 AS blank24_98,
  t0.blank25 AS blank25_99,
  t0.blank26 AS blank26_100,
  t0.blank27 AS blank27_101,
  t0.blank28 AS blank28_102,
  t0.blank29 AS blank29_103,
  t0.blank30 AS blank30_104,
  t0.newcate AS newcate_105,
  t0.dspfl AS dspfl_106,
  t0.parent_category_id AS parent_category_id_107,
  t0.creator_id AS creator_id_108,
  t0.discriminator_type
FROM
  dtb_category t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('category')
LIMIT
  1

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.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('category') LIMIT 1;

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.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, t0.discriminator_type FROM dtb_category t0 WHERE t0.parent_category_id = ? AND t0.discriminator_type IN ('category') ORDER BY t0.sort_no DESC

[
  1
]

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.url AS url_7,
  t0.title_image_path AS title_image_path_8,
  t0.teikikoudoku1 AS teikikoudoku1_9,
  t0.teikikoudoku2 AS teikikoudoku2_10,
  t0.menuno AS menuno_11,
  t0.kankou AS kankou_12,
  t0.hatsubaibi AS hatsubaibi_13,
  t0.newno AS newno_14,
  t0.linkimage01 AS linkimage01_15,
  t0.linkimage02 AS linkimage02_16,
  t0.linkimage03 AS linkimage03_17,
  t0.linkimage04 AS linkimage04_18,
  t0.linkimage05 AS linkimage05_19,
  t0.linkimage06 AS linkimage06_20,
  t0.linkimage07 AS linkimage07_21,
  t0.linkimage08 AS linkimage08_22,
  t0.linkimage09 AS linkimage09_23,
  t0.linkimage10 AS linkimage10_24,
  t0.linkimage11 AS linkimage11_25,
  t0.linkimage12 AS linkimage12_26,
  t0.linkimage13 AS linkimage13_27,
  t0.linkimage14 AS linkimage14_28,
  t0.linkimage15 AS linkimage15_29,
  t0.linkimage16 AS linkimage16_30,
  t0.linkimage17 AS linkimage17_31,
  t0.linkimage18 AS linkimage18_32,
  t0.linkimage19 AS linkimage19_33,
  t0.linkimage20 AS linkimage20_34,
  t0.linkimage21 AS linkimage21_35,
  t0.linkimage22 AS linkimage22_36,
  t0.linkimage23 AS linkimage23_37,
  t0.linkimage24 AS linkimage24_38,
  t0.linkimage25 AS linkimage25_39,
  t0.linkimage26 AS linkimage26_40,
  t0.linkimage27 AS linkimage27_41,
  t0.linkimage28 AS linkimage28_42,
  t0.linkimage29 AS linkimage29_43,
  t0.linkimage30 AS linkimage30_44,
  t0.link01 AS link01_45,
  t0.link02 AS link02_46,
  t0.link03 AS link03_47,
  t0.link04 AS link04_48,
  t0.link05 AS link05_49,
  t0.link06 AS link06_50,
  t0.link07 AS link07_51,
  t0.link08 AS link08_52,
  t0.link09 AS link09_53,
  t0.link10 AS link10_54,
  t0.link11 AS link11_55,
  t0.link12 AS link12_56,
  t0.link13 AS link13_57,
  t0.link14 AS link14_58,
  t0.link15 AS link15_59,
  t0.link16 AS link16_60,
  t0.link17 AS link17_61,
  t0.link18 AS link18_62,
  t0.link19 AS link19_63,
  t0.link20 AS link20_64,
  t0.link21 AS link21_65,
  t0.link22 AS link22_66,
  t0.link23 AS link23_67,
  t0.link24 AS link24_68,
  t0.link25 AS link25_69,
  t0.link26 AS link26_70,
  t0.link27 AS link27_71,
  t0.link28 AS link28_72,
  t0.link29 AS link29_73,
  t0.link30 AS link30_74,
  t0.blank01 AS blank01_75,
  t0.blank02 AS blank02_76,
  t0.blank03 AS blank03_77,
  t0.blank04 AS blank04_78,
  t0.blank05 AS blank05_79,
  t0.blank06 AS blank06_80,
  t0.blank07 AS blank07_81,
  t0.blank08 AS blank08_82,
  t0.blank09 AS blank09_83,
  t0.blank10 AS blank10_84,
  t0.blank11 AS blank11_85,
  t0.blank12 AS blank12_86,
  t0.blank13 AS blank13_87,
  t0.blank14 AS blank14_88,
  t0.blank15 AS blank15_89,
  t0.blank16 AS blank16_90,
  t0.blank17 AS blank17_91,
  t0.blank18 AS blank18_92,
  t0.blank19 AS blank19_93,
  t0.blank20 AS blank20_94,
  t0.blank21 AS blank21_95,
  t0.blank22 AS blank22_96,
  t0.blank23 AS blank23_97,
  t0.blank24 AS blank24_98,
  t0.blank25 AS blank25_99,
  t0.blank26 AS blank26_100,
  t0.blank27 AS blank27_101,
  t0.blank28 AS blank28_102,
  t0.blank29 AS blank29_103,
  t0.blank30 AS blank30_104,
  t0.newcate AS newcate_105,
  t0.dspfl AS dspfl_106,
  t0.parent_category_id AS parent_category_id_107,
  t0.creator_id AS creator_id_108,
  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.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, 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 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_.url AS url_6, d0_.title_image_path AS title_image_path_7, d0_.teikikoudoku1 AS teikikoudoku1_8, d0_.teikikoudoku2 AS teikikoudoku2_9, d0_.menuno AS menuno_10, d0_.kankou AS kankou_11, d0_.hatsubaibi AS hatsubaibi_12, d0_.newno AS newno_13, d0_.linkimage01 AS linkimage01_14, d0_.linkimage02 AS linkimage02_15, d0_.linkimage03 AS linkimage03_16, d0_.linkimage04 AS linkimage04_17, d0_.linkimage05 AS linkimage05_18, d0_.linkimage06 AS linkimage06_19, d0_.linkimage07 AS linkimage07_20, d0_.linkimage08 AS linkimage08_21, d0_.linkimage09 AS linkimage09_22, d0_.linkimage10 AS linkimage10_23, d0_.linkimage11 AS linkimage11_24, d0_.linkimage12 AS linkimage12_25, d0_.linkimage13 AS linkimage13_26, d0_.linkimage14 AS linkimage14_27, d0_.linkimage15 AS linkimage15_28, d0_.linkimage16 AS linkimage16_29, d0_.linkimage17 AS linkimage17_30, d0_.linkimage18 AS linkimage18_31, d0_.linkimage19 AS linkimage19_32, d0_.linkimage20 AS linkimage20_33, d0_.linkimage21 AS linkimage21_34, d0_.linkimage22 AS linkimage22_35, d0_.linkimage23 AS linkimage23_36, d0_.linkimage24 AS linkimage24_37, d0_.linkimage25 AS linkimage25_38, d0_.linkimage26 AS linkimage26_39, d0_.linkimage27 AS linkimage27_40, d0_.linkimage28 AS linkimage28_41, d0_.linkimage29 AS linkimage29_42, d0_.linkimage30 AS linkimage30_43, d0_.link01 AS link01_44, d0_.link02 AS link02_45, d0_.link03 AS link03_46, d0_.link04 AS link04_47, d0_.link05 AS link05_48, d0_.link06 AS link06_49, d0_.link07 AS link07_50, d0_.link08 AS link08_51, d0_.link09 AS link09_52, d0_.link10 AS link10_53, d0_.link11 AS link11_54, d0_.link12 AS link12_55, d0_.link13 AS link13_56, d0_.link14 AS link14_57, d0_.link15 AS link15_58, d0_.link16 AS link16_59, d0_.link17 AS link17_60, d0_.link18 AS link18_61, d0_.link19 AS link19_62, d0_.link20 AS link20_63, d0_.link21 AS link21_64, d0_.link22 AS link22_65, d0_.link23 AS link23_66, d0_.link24 AS link24_67, d0_.link25 AS link25_68, d0_.link26 AS link26_69, d0_.link27 AS link27_70, d0_.link28 AS link28_71, d0_.link29 AS link29_72, d0_.link30 AS link30_73, d0_.blank01 AS blank01_74, d0_.blank02 AS blank02_75, d0_.blank03 AS blank03_76, d0_.blank04 AS blank04_77, d0_.blank05 AS blank05_78, d0_.blank06 AS blank06_79, d0_.blank07 AS blank07_80, d0_.blank08 AS blank08_81, d0_.blank09 AS blank09_82, d0_.blank10 AS blank10_83, d0_.blank11 AS blank11_84, d0_.blank12 AS blank12_85, d0_.blank13 AS blank13_86, d0_.blank14 AS blank14_87, d0_.blank15 AS blank15_88, d0_.blank16 AS blank16_89, d0_.blank17 AS blank17_90, d0_.blank18 AS blank18_91, d0_.blank19 AS blank19_92, d0_.blank20 AS blank20_93, d0_.blank21 AS blank21_94, d0_.blank22 AS blank22_95, d0_.blank23 AS blank23_96, d0_.blank24 AS blank24_97, d0_.blank25 AS blank25_98, d0_.blank26 AS blank26_99, d0_.blank27 AS blank27_100, d0_.blank28 AS blank28_101, d0_.blank29 AS blank29_102, d0_.blank30 AS blank30_103, d0_.newcate AS newcate_104, d0_.dspfl AS dspfl_105, d1_.id AS id_106, d1_.category_name AS category_name_107, d1_.hierarchy AS hierarchy_108, d1_.sort_no AS sort_no_109, d1_.create_date AS create_date_110, d1_.update_date AS update_date_111, d1_.url AS url_112, d1_.title_image_path AS title_image_path_113, d1_.teikikoudoku1 AS teikikoudoku1_114, d1_.teikikoudoku2 AS teikikoudoku2_115, d1_.menuno AS menuno_116, d1_.kankou AS kankou_117, d1_.hatsubaibi AS hatsubaibi_118, d1_.newno AS newno_119, d1_.linkimage01 AS linkimage01_120, d1_.linkimage02 AS linkimage02_121, d1_.linkimage03 AS linkimage03_122, d1_.linkimage04 AS linkimage04_123, d1_.linkimage05 AS linkimage05_124, d1_.linkimage06 AS linkimage06_125, d1_.linkimage07 AS linkimage07_126, d1_.linkimage08 AS linkimage08_127, d1_.linkimage09 AS linkimage09_128, d1_.linkimage10 AS linkimage10_129, d1_.linkimage11 AS linkimage11_130, d1_.linkimage12 AS linkimage12_131, d1_.linkimage13 AS linkimage13_132, d1_.linkimage14 AS linkimage14_133, d1_.linkimage15 AS linkimage15_134, d1_.linkimage16 AS linkimage16_135, d1_.linkimage17 AS linkimage17_136, d1_.linkimage18 AS linkimage18_137, d1_.linkimage19 AS linkimage19_138, d1_.linkimage20 AS linkimage20_139, d1_.linkimage21 AS linkimage21_140, d1_.linkimage22 AS linkimage22_141, d1_.linkimage23 AS linkimage23_142, d1_.linkimage24 AS linkimage24_143, d1_.linkimage25 AS linkimage25_144, d1_.linkimage26 AS linkimage26_145, d1_.linkimage27 AS linkimage27_146, d1_.linkimage28 AS linkimage28_147, d1_.linkimage29 AS linkimage29_148, d1_.linkimage30 AS linkimage30_149, d1_.link01 AS link01_150, d1_.link02 AS link02_151, d1_.link03 AS link03_152, d1_.link04 AS link04_153, d1_.link05 AS link05_154, d1_.link06 AS link06_155, d1_.link07 AS link07_156, d1_.link08 AS link08_157, d1_.link09 AS link09_158, d1_.link10 AS link10_159, d1_.link11 AS link11_160, d1_.link12 AS link12_161, d1_.link13 AS link13_162, d1_.link14 AS link14_163, d1_.link15 AS link15_164, d1_.link16 AS link16_165, d1_.link17 AS link17_166, d1_.link18 AS link18_167, d1_.link19 AS link19_168, d1_.link20 AS link20_169, d1_.link21 AS link21_170, d1_.link22 AS link22_171, d1_.link23 AS link23_172, d1_.link24 AS link24_173, d1_.link25 AS link25_174, d1_.link26 AS link26_175, d1_.link27 AS link27_176, d1_.link28 AS link28_177, d1_.link29 AS link29_178, d1_.link30 AS link30_179, d1_.blank01 AS blank01_180, d1_.blank02 AS blank02_181, d1_.blank03 AS blank03_182, d1_.blank04 AS blank04_183, d1_.blank05 AS blank05_184, d1_.blank06 AS blank06_185, d1_.blank07 AS blank07_186, d1_.blank08 AS blank08_187, d1_.blank09 AS blank09_188, d1_.blank10 AS blank10_189, d1_.blank11 AS blank11_190, d1_.blank12 AS blank12_191, d1_.blank13 AS blank13_192, d1_.blank14 AS blank14_193, d1_.blank15 AS blank15_194, d1_.blank16 AS blank16_195, d1_.blank17 AS blank17_196, d1_.blank18 AS blank18_197, d1_.blank19 AS blank19_198, d1_.blank20 AS blank20_199, d1_.blank21 AS blank21_200, d1_.blank22 AS blank22_201, d1_.blank23 AS blank23_202, d1_.blank24 AS blank24_203, d1_.blank25 AS blank25_204, d1_.blank26 AS blank26_205, d1_.blank27 AS blank27_206, d1_.blank28 AS blank28_207, d1_.blank29 AS blank29_208, d1_.blank30 AS blank30_209, d1_.newcate AS newcate_210, d1_.dspfl AS dspfl_211, d2_.id AS id_212, d2_.category_name AS category_name_213, d2_.hierarchy AS hierarchy_214, d2_.sort_no AS sort_no_215, d2_.create_date AS create_date_216, d2_.update_date AS update_date_217, d2_.url AS url_218, d2_.title_image_path AS title_image_path_219, d2_.teikikoudoku1 AS teikikoudoku1_220, d2_.teikikoudoku2 AS teikikoudoku2_221, d2_.menuno AS menuno_222, d2_.kankou AS kankou_223, d2_.hatsubaibi AS hatsubaibi_224, d2_.newno AS newno_225, d2_.linkimage01 AS linkimage01_226, d2_.linkimage02 AS linkimage02_227, d2_.linkimage03 AS linkimage03_228, d2_.linkimage04 AS linkimage04_229, d2_.linkimage05 AS linkimage05_230, d2_.linkimage06 AS linkimage06_231, d2_.linkimage07 AS linkimage07_232, d2_.linkimage08 AS linkimage08_233, d2_.linkimage09 AS linkimage09_234, d2_.linkimage10 AS linkimage10_235, d2_.linkimage11 AS linkimage11_236, d2_.linkimage12 AS linkimage12_237, d2_.linkimage13 AS linkimage13_238, d2_.linkimage14 AS linkimage14_239, d2_.linkimage15 AS linkimage15_240, d2_.linkimage16 AS linkimage16_241, d2_.linkimage17 AS linkimage17_242, d2_.linkimage18 AS linkimage18_243, d2_.linkimage19 AS linkimage19_244, d2_.linkimage20 AS linkimage20_245, d2_.linkimage21 AS linkimage21_246, d2_.linkimage22 AS linkimage22_247, d2_.linkimage23 AS linkimage23_248, d2_.linkimage24 AS linkimage24_249, d2_.linkimage25 AS linkimage25_250, d2_.linkimage26 AS linkimage26_251, d2_.linkimage27 AS linkimage27_252, d2_.linkimage28 AS linkimage28_253, d2_.linkimage29 AS linkimage29_254, d2_.linkimage30 AS linkimage30_255, d2_.link01 AS link01_256, d2_.link02 AS link02_257, d2_.link03 AS link03_258, d2_.link04 AS link04_259, d2_.link05 AS link05_260, d2_.link06 AS link06_261, d2_.link07 AS link07_262, d2_.link08 AS link08_263, d2_.link09 AS link09_264, d2_.link10 AS link10_265, d2_.link11 AS link11_266, d2_.link12 AS link12_267, d2_.link13 AS link13_268, d2_.link14 AS link14_269, d2_.link15 AS link15_270, d2_.link16 AS link16_271, d2_.link17 AS link17_272, d2_.link18 AS link18_273, d2_.link19 AS link19_274, d2_.link20 AS link20_275, d2_.link21 AS link21_276, d2_.link22 AS link22_277, d2_.link23 AS link23_278, d2_.link24 AS link24_279, d2_.link25 AS link25_280, d2_.link26 AS link26_281, d2_.link27 AS link27_282, d2_.link28 AS link28_283, d2_.link29 AS link29_284, d2_.link30 AS link30_285, d2_.blank01 AS blank01_286, d2_.blank02 AS blank02_287, d2_.blank03 AS blank03_288, d2_.blank04 AS blank04_289, d2_.blank05 AS blank05_290, d2_.blank06 AS blank06_291, d2_.blank07 AS blank07_292, d2_.blank08 AS blank08_293, d2_.blank09 AS blank09_294, d2_.blank10 AS blank10_295, d2_.blank11 AS blank11_296, d2_.blank12 AS blank12_297, d2_.blank13 AS blank13_298, d2_.blank14 AS blank14_299, d2_.blank15 AS blank15_300, d2_.blank16 AS blank16_301, d2_.blank17 AS blank17_302, d2_.blank18 AS blank18_303, d2_.blank19 AS blank19_304, d2_.blank20 AS blank20_305, d2_.blank21 AS blank21_306, d2_.blank22 AS blank22_307, d2_.blank23 AS blank23_308, d2_.blank24 AS blank24_309, d2_.blank25 AS blank25_310, d2_.blank26 AS blank26_311, d2_.blank27 AS blank27_312, d2_.blank28 AS blank28_313, d2_.blank29 AS blank29_314, d2_.blank30 AS blank30_315, d2_.newcate AS newcate_316, d2_.dspfl AS dspfl_317, d3_.id AS id_318, d3_.category_name AS category_name_319, d3_.hierarchy AS hierarchy_320, d3_.sort_no AS sort_no_321, d3_.create_date AS create_date_322, d3_.update_date AS update_date_323, d3_.url AS url_324, d3_.title_image_path AS title_image_path_325, d3_.teikikoudoku1 AS teikikoudoku1_326, d3_.teikikoudoku2 AS teikikoudoku2_327, d3_.menuno AS menuno_328, d3_.kankou AS kankou_329, d3_.hatsubaibi AS hatsubaibi_330, d3_.newno AS newno_331, d3_.linkimage01 AS linkimage01_332, d3_.linkimage02 AS linkimage02_333, d3_.linkimage03 AS linkimage03_334, d3_.linkimage04 AS linkimage04_335, d3_.linkimage05 AS linkimage05_336, d3_.linkimage06 AS linkimage06_337, d3_.linkimage07 AS linkimage07_338, d3_.linkimage08 AS linkimage08_339, d3_.linkimage09 AS linkimage09_340, d3_.linkimage10 AS linkimage10_341, d3_.linkimage11 AS linkimage11_342, d3_.linkimage12 AS linkimage12_343, d3_.linkimage13 AS linkimage13_344, d3_.linkimage14 AS linkimage14_345, d3_.linkimage15 AS linkimage15_346, d3_.linkimage16 AS linkimage16_347, d3_.linkimage17 AS linkimage17_348, d3_.linkimage18 AS linkimage18_349, d3_.linkimage19 AS linkimage19_350, d3_.linkimage20 AS linkimage20_351, d3_.linkimage21 AS linkimage21_352, d3_.linkimage22 AS linkimage22_353, d3_.linkimage23 AS linkimage23_354, d3_.linkimage24 AS linkimage24_355, d3_.linkimage25 AS linkimage25_356, d3_.linkimage26 AS linkimage26_357, d3_.linkimage27 AS linkimage27_358, d3_.linkimage28 AS linkimage28_359, d3_.linkimage29 AS linkimage29_360, d3_.linkimage30 AS linkimage30_361, d3_.link01 AS link01_362, d3_.link02 AS link02_363, d3_.link03 AS link03_364, d3_.link04 AS link04_365, d3_.link05 AS link05_366, d3_.link06 AS link06_367, d3_.link07 AS link07_368, d3_.link08 AS link08_369, d3_.link09 AS link09_370, d3_.link10 AS link10_371, d3_.link11 AS link11_372, d3_.link12 AS link12_373, d3_.link13 AS link13_374, d3_.link14 AS link14_375, d3_.link15 AS link15_376, d3_.link16 AS link16_377, d3_.link17 AS link17_378, d3_.link18 AS link18_379, d3_.link19 AS link19_380, d3_.link20 AS link20_381, d3_.link21 AS link21_382, d3_.link22 AS link22_383, d3_.link23 AS link23_384, d3_.link24 AS link24_385, d3_.link25 AS link25_386, d3_.link26 AS link26_387, d3_.link27 AS link27_388, d3_.link28 AS link28_389, d3_.link29 AS link29_390, d3_.link30 AS link30_391, d3_.blank01 AS blank01_392, d3_.blank02 AS blank02_393, d3_.blank03 AS blank03_394, d3_.blank04 AS blank04_395, d3_.blank05 AS blank05_396, d3_.blank06 AS blank06_397, d3_.blank07 AS blank07_398, d3_.blank08 AS blank08_399, d3_.blank09 AS blank09_400, d3_.blank10 AS blank10_401, d3_.blank11 AS blank11_402, d3_.blank12 AS blank12_403, d3_.blank13 AS blank13_404, d3_.blank14 AS blank14_405, d3_.blank15 AS blank15_406, d3_.blank16 AS blank16_407, d3_.blank17 AS blank17_408, d3_.blank18 AS blank18_409, d3_.blank19 AS blank19_410, d3_.blank20 AS blank20_411, d3_.blank21 AS blank21_412, d3_.blank22 AS blank22_413, d3_.blank23 AS blank23_414, d3_.blank24 AS blank24_415, d3_.blank25 AS blank25_416, d3_.blank26 AS blank26_417, d3_.blank27 AS blank27_418, d3_.blank28 AS blank28_419, d3_.blank29 AS blank29_420, d3_.blank30 AS blank30_421, d3_.newcate AS newcate_422, d3_.dspfl AS dspfl_423, d4_.id AS id_424, d4_.category_name AS category_name_425, d4_.hierarchy AS hierarchy_426, d4_.sort_no AS sort_no_427, d4_.create_date AS create_date_428, d4_.update_date AS update_date_429, d4_.url AS url_430, d4_.title_image_path AS title_image_path_431, d4_.teikikoudoku1 AS teikikoudoku1_432, d4_.teikikoudoku2 AS teikikoudoku2_433, d4_.menuno AS menuno_434, d4_.kankou AS kankou_435, d4_.hatsubaibi AS hatsubaibi_436, d4_.newno AS newno_437, d4_.linkimage01 AS linkimage01_438, d4_.linkimage02 AS linkimage02_439, d4_.linkimage03 AS linkimage03_440, d4_.linkimage04 AS linkimage04_441, d4_.linkimage05 AS linkimage05_442, d4_.linkimage06 AS linkimage06_443, d4_.linkimage07 AS linkimage07_444, d4_.linkimage08 AS linkimage08_445, d4_.linkimage09 AS linkimage09_446, d4_.linkimage10 AS linkimage10_447, d4_.linkimage11 AS linkimage11_448, d4_.linkimage12 AS linkimage12_449, d4_.linkimage13 AS linkimage13_450, d4_.linkimage14 AS linkimage14_451, d4_.linkimage15 AS linkimage15_452, d4_.linkimage16 AS linkimage16_453, d4_.linkimage17 AS linkimage17_454, d4_.linkimage18 AS linkimage18_455, d4_.linkimage19 AS linkimage19_456, d4_.linkimage20 AS linkimage20_457, d4_.linkimage21 AS linkimage21_458, d4_.linkimage22 AS linkimage22_459, d4_.linkimage23 AS linkimage23_460, d4_.linkimage24 AS linkimage24_461, d4_.linkimage25 AS linkimage25_462, d4_.linkimage26 AS linkimage26_463, d4_.linkimage27 AS linkimage27_464, d4_.linkimage28 AS linkimage28_465, d4_.linkimage29 AS linkimage29_466, d4_.linkimage30 AS linkimage30_467, d4_.link01 AS link01_468, d4_.link02 AS link02_469, d4_.link03 AS link03_470, d4_.link04 AS link04_471, d4_.link05 AS link05_472, d4_.link06 AS link06_473, d4_.link07 AS link07_474, d4_.link08 AS link08_475, d4_.link09 AS link09_476, d4_.link10 AS link10_477, d4_.link11 AS link11_478, d4_.link12 AS link12_479, d4_.link13 AS link13_480, d4_.link14 AS link14_481, d4_.link15 AS link15_482, d4_.link16 AS link16_483, d4_.link17 AS link17_484, d4_.link18 AS link18_485, d4_.link19 AS link19_486, d4_.link20 AS link20_487, d4_.link21 AS link21_488, d4_.link22 AS link22_489, d4_.link23 AS link23_490, d4_.link24 AS link24_491, d4_.link25 AS link25_492, d4_.link26 AS link26_493, d4_.link27 AS link27_494, d4_.link28 AS link28_495, d4_.link29 AS link29_496, d4_.link30 AS link30_497, d4_.blank01 AS blank01_498, d4_.blank02 AS blank02_499, d4_.blank03 AS blank03_500, d4_.blank04 AS blank04_501, d4_.blank05 AS blank05_502, d4_.blank06 AS blank06_503, d4_.blank07 AS blank07_504, d4_.blank08 AS blank08_505, d4_.blank09 AS blank09_506, d4_.blank10 AS blank10_507, d4_.blank11 AS blank11_508, d4_.blank12 AS blank12_509, d4_.blank13 AS blank13_510, d4_.blank14 AS blank14_511, d4_.blank15 AS blank15_512, d4_.blank16 AS blank16_513, d4_.blank17 AS blank17_514, d4_.blank18 AS blank18_515, d4_.blank19 AS blank19_516, d4_.blank20 AS blank20_517, d4_.blank21 AS blank21_518, d4_.blank22 AS blank22_519, d4_.blank23 AS blank23_520, d4_.blank24 AS blank24_521, d4_.blank25 AS blank25_522, d4_.blank26 AS blank26_523, d4_.blank27 AS blank27_524, d4_.blank28 AS blank28_525, d4_.blank29 AS blank29_526, d4_.blank30 AS blank30_527, d4_.newcate AS newcate_528, d4_.dspfl AS dspfl_529, d0_.discriminator_type AS discriminator_type_530, d0_.parent_category_id AS parent_category_id_531, d0_.creator_id AS creator_id_532, d1_.discriminator_type AS discriminator_type_533, d1_.parent_category_id AS parent_category_id_534, d1_.creator_id AS creator_id_535, d2_.discriminator_type AS discriminator_type_536, d2_.parent_category_id AS parent_category_id_537, d2_.creator_id AS creator_id_538, d3_.discriminator_type AS discriminator_type_539, d3_.parent_category_id AS parent_category_id_540, d3_.creator_id AS creator_id_541, d4_.discriminator_type AS discriminator_type_542, d4_.parent_category_id AS parent_category_id_543, d4_.creator_id AS creator_id_544 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 ASC, d2_.sort_no ASC, d3_.sort_no ASC, d4_.sort_no ASC