[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.001888s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.001869s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.001962s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.001859s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.002423s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.001953s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.002164s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.001968s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.001856s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.001970s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.001965s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.001699s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.001727s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.001730s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.001843s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.001868s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.001761s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.001830s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.001725s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.001903s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.002026s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.001790s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.002561s ]
[ 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.002430s ]
[ 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 30,6 [ RunTime:0.002225s ]
