[ DB ] CONNECT:[ UseTime:0.000296s ] mysql:dbname=test-scjjpx;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_article_cat` [ RunTime:0.000717s ]
[ SQL ] SELECT `cat_id`,`cat_name` FROM `tp_article_cat` WHERE ( show_in_nav = 1 and parent_id = 0 ) ORDER BY sort_order asc,cat_id asc [ RunTime:0.000177s ]
[ SQL ] SHOW COLUMNS FROM `tp_course_cat` [ RunTime:0.000670s ]
[ SQL ] SELECT `cat_id`,`cat_name` FROM `tp_course_cat` WHERE ( parent_id = 0 ) ORDER BY sort_order asc,cat_id asc [ RunTime:0.000167s ]
[ SQL ] SELECT `cat_id`,`cat_name` FROM `tp_article_cat` WHERE ( show_in_nav = 1 and parent_id = 102 ) ORDER BY sort_order asc,cat_id asc [ RunTime:0.000134s ]
[ SQL ] SELECT `cat_id`,`cat_name` FROM `tp_article_cat` WHERE ( show_in_nav = 1 and parent_id = 92 ) ORDER BY sort_order asc,cat_id asc [ RunTime:0.000127s ]
[ SQL ] SELECT `cat_id`,`cat_name` FROM `tp_article_cat` WHERE ( show_in_nav = 1 and parent_id = 94 ) ORDER BY sort_order asc,cat_id asc [ RunTime:0.000119s ]
[ SQL ] SHOW COLUMNS FROM `tp_article` [ RunTime:0.000664s ]
[ SQL ] SELECT * FROM `tp_article` WHERE ( cat_id in(102) and is_open = 1 ) ORDER BY add_time desc LIMIT 9 [ RunTime:0.000680s ]
[ SQL ] SELECT * FROM `tp_article` WHERE ( cat_id in(92) and is_open = 1 ) ORDER BY add_time desc LIMIT 9 [ RunTime:0.000885s ]
[ SQL ] SELECT * FROM `tp_article` WHERE ( cat_id in(94) and is_open = 1 ) ORDER BY add_time desc LIMIT 9 [ RunTime:0.002245s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 10 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2100 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2102 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000122s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2103 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000129s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2200 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000123s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2804 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000116s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2250 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000115s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2300 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000115s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2600 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000126s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2803 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000126s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2807 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000116s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2500 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000114s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2802 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000113s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2801 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000129s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2806 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000120s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2805 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000115s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2400 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000114s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE ( parent_id = 0 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000112s ]
[ SQL ] SELECT `a`.*,sum(b.price) as price FROM `tp_course_cat` `a` LEFT JOIN `tp_course` `b` ON `a`.`cat_id`=`b`.`cat_id` WHERE ( a.is_open = 1 and a.parent_id = 1 ) GROUP BY a.cat_id ORDER BY a.sort_order ASC LIMIT 12 [ RunTime:0.000352s ]
[ SQL ] SELECT `a`.*,sum(b.price) as price FROM `tp_course_cat` `a` LEFT JOIN `tp_course` `b` ON `a`.`cat_id`=`b`.`cat_id` WHERE ( a.is_open = 1 and a.parent_id = 10 ) GROUP BY a.cat_id ORDER BY a.sort_order ASC LIMIT 12 [ RunTime:0.002807s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 10 AND `is_open` = 1 [ RunTime:0.000179s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2600 AND `is_open` = 1 [ RunTime:0.000113s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2500 AND `is_open` = 1 [ RunTime:0.000128s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2400 AND `is_open` = 1 [ RunTime:0.000105s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2100 AND `is_open` = 1 [ RunTime:0.000112s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2103 AND `is_open` = 1 [ RunTime:0.000103s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2102 AND `is_open` = 1 [ RunTime:0.000113s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2200 AND `is_open` = 1 [ RunTime:0.000106s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2300 AND `is_open` = 1 [ RunTime:0.000100s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2807 AND `is_open` = 1 [ RunTime:0.000099s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2806 AND `is_open` = 1 [ RunTime:0.000099s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2805 AND `is_open` = 1 [ RunTime:0.000103s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2804 AND `is_open` = 1 [ RunTime:0.000105s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2803 AND `is_open` = 1 [ RunTime:0.000099s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2802 AND `is_open` = 1 [ RunTime:0.000099s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2801 AND `is_open` = 1 [ RunTime:0.000098s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2250 AND `is_open` = 1 [ RunTime:0.000117s ]
[ SQL ] SHOW COLUMNS FROM `tp_course` [ RunTime:0.000690s ]
[ SQL ] SELECT `c`.`course_id`,`c`.`title`,`c`.`thumb`,`c`.`hour`,`c`.`price`,`c`.`cat_id`,`cc`.`cat_name` FROM `tp_course` `c` LEFT JOIN `tp_course_cat` `cc` ON `c`.`cat_id`=`cc`.`cat_id` WHERE `c`.`cat_id` IN (10,2600,2500,2400,2100,2103,2102,2200,2300,2807,2806,2805,2804,2803,2802,2801,2250) AND `c`.`is_open` = 1 ORDER BY c.sort asc LIMIT 5 [ RunTime:0.002861s ]
[ SQL ] SELECT * FROM `tp_article` WHERE ( cat_id = 102 and is_open = 1 ) ORDER BY add_time desc LIMIT 9 [ RunTime:0.000375s ]
[ SQL ] SHOW COLUMNS FROM `tp_friend_link` [ RunTime:0.000589s ]
[ SQL ] SELECT * FROM `tp_friend_link` WHERE ( is_show = 1 ) ORDER BY link_id desc LIMIT 12 [ RunTime:0.000388s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad_position` [ RunTime:0.000593s ]
[ SQL ] SELECT `position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000316s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad` [ RunTime:0.000627s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=51317 and enabled = 1 and start_time < 1780495200 and end_time > 1780495200 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000395s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=51318 and enabled = 1 and start_time < 1780495200 and end_time > 1780495200 ) ORDER BY orderby desc LIMIT 5 [ RunTime:0.000206s ]
