1709376854
%255B6c3b83d4894010506d9df1753e21b72c6b337f35%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=94f82985f84187c7429ade13231dd0e5eaca99750c7b4087e4e33e27d35023af";a:4:{i:0;a:45:{s:4:"id_0";s:1:"7";s:15:"category_name_1";s:10:"MEISHI LAW";s:11:"hierarchy_2";s:1:"1";s:9:"sort_no_3";s:1:"4";s:13:"create_date_4";s:19:"2021-03-21 05:34:51";s:13:"update_date_5";s:19:"2021-03-21 05:44:15";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:"8";s:15:"category_name_1";s:10:"MEISHI MID";s:11:"hierarchy_2";s:1:"1";s:9:"sort_no_3";s:1:"3";s:13:"create_date_4";s:19:"2021-03-21 05:35:30";s:13:"update_date_5";s:19:"2021-03-21 05:44:15";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:"9";s:15:"category_name_1";s:15:"MEISHI ORIGINAL";s:11:"hierarchy_2";s:1:"1";s:9:"sort_no_3";s:1:"2";s:13:"create_date_4";s:19:"2021-03-21 05:35:39";s:13:"update_date_5";s:19:"2021-03-21 05:44:15";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:3;a:45:{s:4:"id_0";s:1:"2";s:15:"category_name_1";s:9:"新入荷";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-21 05:44:15";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;}}}