[ DB ] CONNECT:[ UseTime:0.000362s ] mysql:dbname=test-scjjpx;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_article_cat` [ RunTime:0.000966s ]
[ 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.000184s ]
[ SQL ] SHOW COLUMNS FROM `tp_course_cat` [ RunTime:0.000783s ]
[ SQL ] SELECT `cat_id`,`cat_name` FROM `tp_course_cat` WHERE ( parent_id = 0 ) ORDER BY sort_order asc,cat_id asc [ RunTime:0.000179s ]
[ 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.000141s ]
[ 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.000140s ]
[ 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.000129s ]
[ SQL ] SHOW COLUMNS FROM `tp_article` [ RunTime:0.000752s ]
[ SQL ] SELECT * FROM `tp_article` WHERE ( cat_id in(102) and is_open = 1 ) ORDER BY add_time desc LIMIT 9 [ RunTime:0.000489s ]
[ SQL ] SELECT * FROM `tp_article` WHERE ( cat_id in(92) and is_open = 1 ) ORDER BY add_time desc LIMIT 9 [ RunTime:0.000601s ]
[ SQL ] SELECT * FROM `tp_article` WHERE ( cat_id in(94) and is_open = 1 ) ORDER BY add_time desc LIMIT 9 [ RunTime:0.000668s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 10 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2100 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000175s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2102 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2103 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000130s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2200 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2804 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2250 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000135s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2300 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000129s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2600 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000128s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2803 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000137s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2807 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2500 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000130s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2802 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000133s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2801 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000187s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2806 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2805 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000132s ]
[ SQL ] SELECT * FROM `tp_course_cat` WHERE ( parent_id = 2400 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000128s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE ( parent_id = 0 and is_open = 1 ) ORDER BY sort_order asc [ RunTime:0.000137s ]
[ 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.000394s ]
[ 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.003223s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 10 AND `is_open` = 1 [ RunTime:0.000217s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2600 AND `is_open` = 1 [ RunTime:0.000129s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2500 AND `is_open` = 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2400 AND `is_open` = 1 [ RunTime:0.000124s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2100 AND `is_open` = 1 [ RunTime:0.000122s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2103 AND `is_open` = 1 [ RunTime:0.000119s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2102 AND `is_open` = 1 [ RunTime:0.000111s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2200 AND `is_open` = 1 [ RunTime:0.000118s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2300 AND `is_open` = 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2807 AND `is_open` = 1 [ RunTime:0.000117s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2806 AND `is_open` = 1 [ RunTime:0.000110s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2805 AND `is_open` = 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2804 AND `is_open` = 1 [ RunTime:0.000138s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2803 AND `is_open` = 1 [ RunTime:0.000123s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2802 AND `is_open` = 1 [ RunTime:0.000111s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2801 AND `is_open` = 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `cat_id` FROM `tp_course_cat` WHERE `parent_id` = 2250 AND `is_open` = 1 [ RunTime:0.000120s ]
[ SQL ] SHOW COLUMNS FROM `tp_course` [ RunTime:0.000744s ]
[ 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.003175s ]
[ SQL ] SELECT * FROM `tp_article` WHERE ( cat_id = 102 and is_open = 1 ) ORDER BY add_time desc LIMIT 9 [ RunTime:0.000392s ]
[ SQL ] SHOW COLUMNS FROM `tp_friend_link` [ RunTime:0.000649s ]
[ SQL ] SELECT * FROM `tp_friend_link` WHERE ( is_show = 1 ) ORDER BY link_id desc LIMIT 12 [ RunTime:0.000143s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad_position` [ RunTime:0.000682s ]
[ SQL ] SELECT `position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000127s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad` [ RunTime:0.000706s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=51317 and enabled = 1 and start_time < 1780498800 and end_time > 1780498800 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000234s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=51318 and enabled = 1 and start_time < 1780498800 and end_time > 1780498800 ) ORDER BY orderby desc LIMIT 5 [ RunTime:0.000218s ]
