[ DB ] CONNECT:[ UseTime:0.000470s ] mysql:host=127.0.0.1;port=3306;dbname=ai;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tryine_banner_list` [ RunTime:0.001248s ]
[ SQL ] SELECT * FROM `tryine_banner_list` WHERE ( delete_flag = 1 and bl_location=5 ) ORDER BY `created_at` DESC LIMIT 1 [ RunTime:0.000403s ]
[ SQL ] SHOW COLUMNS FROM `tryine_link` [ RunTime:0.001364s ]
[ SQL ] SELECT * FROM `tryine_link` WHERE `type` = 1 AND `status` = 1 [ RunTime:0.000466s ]
[ SQL ] SHOW COLUMNS FROM `tryine_portal_category` [ RunTime:0.000905s ]
[ SQL ] SELECT * FROM `tryine_portal_category` WHERE ( type=1 AND delete_time=0 AND parent_id=0 and status=1 and (id<7 or id in(610,611) ) ) LIMIT 10 [ RunTime:0.000485s ]
[ SQL ] SELECT `id`,`name`,`description` FROM `tryine_portal_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000284s ]
[ SQL ] SHOW COLUMNS FROM `tryine_portal_post` [ RunTime:0.001050s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `tryine_portal_post` `pp` LEFT JOIN `tryine_portal_category_post` `pcp` ON `pp`.`id`=`pcp`.`post_id` LEFT JOIN `tryine_portal_category` `pc` ON `pcp`.`category_id`=`pc`.`id` WHERE ( pp.delete_time=0 and post_type=1 and post_status=1 AND pcp.category_id=4 ) GROUP BY `pp`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000820s ]
[ SQL ] SELECT `pp`.*,name as className FROM `tryine_portal_post` `pp` LEFT JOIN `tryine_portal_category_post` `pcp` ON `pp`.`id`=`pcp`.`post_id` LEFT JOIN `tryine_portal_category` `pc` ON `pcp`.`category_id`=`pc`.`id` WHERE ( pp.delete_time=0 and post_type=1 and post_status=1 AND pcp.category_id=4 ) GROUP BY `pp`.`id` ORDER BY `pp`.`is_top` DESC,`pp`.`published_time` DESC LIMIT 40,10 [ RunTime:0.001972s ]
[ SQL ] SELECT `pp`.*,name as className FROM `tryine_portal_post` `pp` LEFT JOIN `tryine_portal_category_post` `pcp` ON `pp`.`id`=`pcp`.`post_id` LEFT JOIN `tryine_portal_category` `pc` ON `pcp`.`category_id`=`pc`.`id` WHERE ( pp.delete_time=0 and post_type=1 and post_status=1 and pc.id=12 ) ORDER BY `pp`.`is_top` DESC,`pp`.`published_time` DESC LIMIT 1 [ RunTime:0.000814s ]
[ SQL ] SELECT `pp`.*,name as className FROM `tryine_portal_post` `pp` LEFT JOIN `tryine_portal_category_post` `pcp` ON `pp`.`id`=`pcp`.`post_id` LEFT JOIN `tryine_portal_category` `pc` ON `pcp`.`category_id`=`pc`.`id` WHERE ( pp.delete_time=0 and post_type=1 and post_status=1 and recommended =1 and pc.id<7 ) GROUP BY `pp`.`id` ORDER BY `pp`.`is_top` DESC,`pp`.`published_time` DESC LIMIT 3 [ RunTime:0.004358s ]
[ SQL ] SELECT * FROM `tryine_banner_list` WHERE `bl_location` = '7' AND `delete_flag` = 1 AND `bl_status` = 1 ORDER BY `bl_order` ASC [ RunTime:0.000420s ]
[ SQL ] SHOW COLUMNS FROM `tryine_theme_file` [ RunTime:0.001143s ]
[ SQL ] SELECT * FROM `tryine_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000291s ]
[ SQL ] SHOW COLUMNS FROM `tryine_theme` [ RunTime:0.000920s ]
[ SQL ] UPDATE `tryine_theme` SET `name`='simpleboot3',`version`='1.0.2',`demo_url`='http://demo.thinkcmf.com',`author`='ThinkCMF',`lang`='zh-cn',`author_url`='http://www.thinkcmf.com',`keywords`='ThinkCMF模板',`description`='ThinkCMF默認模板' WHERE `theme` = 'simpleboot3' [ RunTime:0.003928s ]
[ SQL ] SELECT `more` FROM `tryine_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/news' ) [ RunTime:0.000315s ]
