[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.001171s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.001163s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.001151s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.001190s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.001226s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.001262s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.001172s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.001177s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.001190s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.001202s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.001130s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.001188s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.001188s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.001187s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.001196s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.001171s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.001177s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.001133s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.001178s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.001133s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.001160s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.001150s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.001668s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_category_post` `a` INNER JOIN `cmf_portal_post` `p` ON `a`.`post_id`=`p`.`id` WHERE `a`.`category_id` IN (5,6,7,8,9,10,19,20,21,22) AND ( p.post_status=1 and a.status=1 ) LIMIT 1 [ RunTime:0.001330s ]
[ SQL ] SELECT p.id as id,p.thumbnail as thumb,p.post_title as title FROM `cmf_portal_category_post` `a` INNER JOIN `cmf_portal_post` `p` ON `a`.`post_id`=`p`.`id` WHERE `a`.`category_id` IN (5,6,7,8,9,10,19,20,21,22) AND ( p.post_status=1 and a.status=1 ) ORDER BY `p`.`recommended` DESC,`p`.`published_time` DESC,`p`.`id` DESC LIMIT 36,6 [ RunTime:0.001581s ]
