[ DB ] CONNECT:[ UseTime:0.001456s ] mysql:host=127.0.0.1;port=3306;dbname=ai;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tryine_banner_list` [ RunTime:0.001244s ]
[ SQL ] SELECT * FROM `tryine_banner_list` WHERE ( delete_flag = 1 and bl_location=5 ) ORDER BY `created_at` DESC LIMIT 1 [ RunTime:0.000456s ]
[ SQL ] SHOW COLUMNS FROM `tryine_link` [ RunTime:0.000974s ]
[ SQL ] SELECT * FROM `tryine_link` WHERE `type` = 1 AND `status` = 1 [ RunTime:0.000410s ]
[ SQL ] SHOW COLUMNS FROM `tryine_portal_category` [ RunTime:0.000939s ]
[ 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.000452s ]
[ SQL ] SELECT `id`,`name`,`description` FROM `tryine_portal_category` WHERE `id` = 610 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SHOW COLUMNS FROM `tryine_portal_post` [ RunTime:0.001028s ]
[ 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=610 ) GROUP BY `pp`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000564s ]
[ 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=610 ) GROUP BY `pp`.`id` ORDER BY `pp`.`is_top` DESC,`pp`.`published_time` DESC LIMIT 0,10 [ RunTime:0.000913s ]
[ 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.000816s ]
[ 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.004413s ]
[ 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.000922s ]
[ SQL ] SHOW COLUMNS FROM `tryine_theme_file` [ RunTime:0.002408s ]
[ SQL ] SELECT * FROM `tryine_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000283s ]
[ SQL ] SHOW COLUMNS FROM `tryine_theme` [ RunTime:0.001293s ]
[ 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.003521s ]
[ SQL ] SELECT `more` FROM `tryine_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/news' ) [ RunTime:0.000323s ]