Symfony Profiler

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

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

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 = 'bookcart') AND d0_.discriminator_type IN ('page');

SET
  SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

"START TRANSACTION"

"START TRANSACTION";

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