1709441043
%255Bf60c5aada7a5d598d247f5cd5998c0fc59ca8d2e%255D%255B1%255D
a:1:{s:2307:"query=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, d1_.discriminator_type AS discriminator_type_33, d1_.parent_category_id AS parent_category_id_34, d1_.creator_id AS creator_id_35, d2_.discriminator_type AS discriminator_type_36, d2_.parent_category_id AS parent_category_id_37, d2_.creator_id AS creator_id_38, d3_.discriminator_type AS discriminator_type_39, d3_.parent_category_id AS parent_category_id_40, d3_.creator_id AS creator_id_41, d4_.discriminator_type AS discriminator_type_42, d4_.parent_category_id AS parent_category_id_43, d4_.creator_id AS creator_id_44 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&params=a:0:{}&types=a:0:{}&connectionParams=509274aa47c1178c8f288cf18a38f6bfae0e98b95edfade7958ef370f816e4ed";a:3:{i:0;a:45:{s:4:"id_0";s:1:"2";s:15:"category_name_1";s:15:"スキンケア";s:11:"hierarchy_2";s:1:"1";s:9:"sort_no_3";s:1:"3";s:13:"create_date_4";s:19:"2017-03-07 10:14:52";s:13:"update_date_5";s:19:"2021-03-24 13:19:41";s:4:"id_6";N;s:15:"category_name_7";N;s:11:"hierarchy_8";N;s:9:"sort_no_9";N;s:14:"create_date_10";N;s:14:"update_date_11";N;s:5:"id_12";N;s:16:"category_name_13";N;s:12:"hierarchy_14";N;s:10:"sort_no_15";N;s:14:"create_date_16";N;s:14:"update_date_17";N;s:5:"id_18";N;s:16:"category_name_19";N;s:12:"hierarchy_20";N;s:10:"sort_no_21";N;s:14:"create_date_22";N;s:14:"update_date_23";N;s:5:"id_24";N;s:16:"category_name_25";N;s:12:"hierarchy_26";N;s:10:"sort_no_27";N;s:14:"create_date_28";N;s:14:"update_date_29";N;s:21:"discriminator_type_30";s:8:"category";s:21:"parent_category_id_31";N;s:13:"creator_id_32";s:1:"1";s:21:"discriminator_type_33";N;s:21:"parent_category_id_34";N;s:13:"creator_id_35";N;s:21:"discriminator_type_36";N;s:21:"parent_category_id_37";N;s:13:"creator_id_38";N;s:21:"discriminator_type_39";N;s:21:"parent_category_id_40";N;s:13:"creator_id_41";N;s:21:"discriminator_type_42";N;s:21:"parent_category_id_43";N;s:13:"creator_id_44";N;}i:1;a:45:{s:4:"id_0";s:1:"1";s:15:"category_name_1";s:12:"バスケア";s:11:"hierarchy_2";s:1:"1";s:9:"sort_no_3";s:1:"2";s:13:"create_date_4";s:19:"2017-03-07 10:14:52";s:13:"update_date_5";s:19:"2021-03-24 13:19:41";s:4:"id_6";N;s:15:"category_name_7";N;s:11:"hierarchy_8";N;s:9:"sort_no_9";N;s:14:"create_date_10";N;s:14:"update_date_11";N;s:5:"id_12";N;s:16:"category_name_13";N;s:12:"hierarchy_14";N;s:10:"sort_no_15";N;s:14:"create_date_16";N;s:14:"update_date_17";N;s:5:"id_18";N;s:16:"category_name_19";N;s:12:"hierarchy_20";N;s:10:"sort_no_21";N;s:14:"create_date_22";N;s:14:"update_date_23";N;s:5:"id_24";N;s:16:"category_name_25";N;s:12:"hierarchy_26";N;s:10:"sort_no_27";N;s:14:"create_date_28";N;s:14:"update_date_29";N;s:21:"discriminator_type_30";s:8:"category";s:21:"parent_category_id_31";N;s:13:"creator_id_32";s:1:"1";s:21:"discriminator_type_33";N;s:21:"parent_category_id_34";N;s:13:"creator_id_35";N;s:21:"discriminator_type_36";N;s:21:"parent_category_id_37";N;s:13:"creator_id_38";N;s:21:"discriminator_type_39";N;s:21:"parent_category_id_40";N;s:13:"creator_id_41";N;s:21:"discriminator_type_42";N;s:21:"parent_category_id_43";N;s:13:"creator_id_44";N;}i:2;a:45:{s:4:"id_0";s:1:"5";s:15:"category_name_1";s:18:"メイクアップ";s:11:"hierarchy_2";s:1:"1";s:9:"sort_no_3";s:1:"1";s:13:"create_date_4";s:19:"2017-03-07 10:14:52";s:13:"update_date_5";s:19:"2021-03-24 13:19:41";s:4:"id_6";N;s:15:"category_name_7";N;s:11:"hierarchy_8";N;s:9:"sort_no_9";N;s:14:"create_date_10";N;s:14:"update_date_11";N;s:5:"id_12";N;s:16:"category_name_13";N;s:12:"hierarchy_14";N;s:10:"sort_no_15";N;s:14:"create_date_16";N;s:14:"update_date_17";N;s:5:"id_18";N;s:16:"category_name_19";N;s:12:"hierarchy_20";N;s:10:"sort_no_21";N;s:14:"create_date_22";N;s:14:"update_date_23";N;s:5:"id_24";N;s:16:"category_name_25";N;s:12:"hierarchy_26";N;s:10:"sort_no_27";N;s:14:"create_date_28";N;s:14:"update_date_29";N;s:21:"discriminator_type_30";s:8:"category";s:21:"parent_category_id_31";N;s:13:"creator_id_32";s:1:"1";s:21:"discriminator_type_33";N;s:21:"parent_category_id_34";N;s:13:"creator_id_35";N;s:21:"discriminator_type_36";N;s:21:"parent_category_id_37";N;s:13:"creator_id_38";N;s:21:"discriminator_type_39";N;s:21:"parent_category_id_40";N;s:13:"creator_id_41";N;s:21:"discriminator_type_42";N;s:21:"parent_category_id_43";N;s:13:"creator_id_44";N;}}}