[ DB ] CONNECT:[ UseTime:0.000446s ] mysql:host=127.0.0.1;port=3306;dbname=dexue02;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `bear_config` [ RunTime:0.001749s ]
[ SQL ] SELECT * FROM `bear_config` LIMIT 1 [ RunTime:0.000306s ]
[ SQL ] SHOW COLUMNS FROM `bear_city` [ RunTime:0.001481s ]
[ SQL ] SELECT * FROM `bear_city` WHERE `pinyin` = 'luoyang' AND `leveltype` = 2 LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SHOW COLUMNS FROM `bear_nav` [ RunTime:0.001266s ]
[ SQL ] SELECT * FROM `bear_nav` WHERE `status` = 1 AND `cityid` = 410300 [ RunTime:0.000226s ]
[ SQL ] SHOW COLUMNS FROM `bear_city_config` [ RunTime:0.001257s ]
[ SQL ] SELECT * FROM `bear_city_config` WHERE `cityid` = 410300 LIMIT 1 [ RunTime:0.000251s ]
[ SQL ] SHOW COLUMNS FROM `bear_category` [ RunTime:0.001324s ]
[ SQL ] SELECT * FROM `bear_category` WHERE `status` = 1 AND `id` IN (1,11,47,48,49,50,51,52,53,54,55,12,56,57,58,59,60,61,13,62,63,64,65,14,66,67,68,69,70,71,72,73,420,2,15,74,77,79,84,16,75,76,78,80,83,85,86,87,88,89,90,91,92,93,94,95,96,97,98,17,81,82,100,101,102,103,104,105,106,107,108,109,110,3,18,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,19,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,20,159,160,161,162,163,164,4,21,165,166,167,168,22,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,23,184,185,186,187,188,189,190,191,192,193,194,195,24,196,197,198,199,25,200,201,202,203,204,205,206,5,26,207,208,209,210,211,212,213,214,215,216,217,27,218,219,220,221,222,223,224,225,226,227,228,229,28,230,231,232,233,234,29,235,236,237,238,239,240,241,242,30,243,244,245,246,247,31,248,249,250,251,252,253,254,255,256,6,32,257,258,259,260,261,262,263,264,265,266,267,268,33,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,34,284,285,286,287,288,289,290,291,292,293,294,295,296,35,297,298,299,300,301,302,303,304,305,306,307,308,309,36,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,411,412,413,414,415,425,426,37,328,329,330,331,38,332,333,334,335,336,337,338,339,340,341,39,342,343,344,8,40,345,346,347,348,349,350,351,352,353,354,41,355,356,357,358,359,360,361,362,363,364,42,365,366,367,368,369,43,371,372,373,374,375,376,377,378,379,380,44,381,382,383,384,385,45,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,46,408,409) [ RunTime:0.001732s ]
[ SQL ] SHOW COLUMNS FROM `bear_links` [ RunTime:0.001559s ]
[ SQL ] SELECT * FROM `bear_links` WHERE `status` = 1 AND `cityid` = 410300 [ RunTime:0.000249s ]
[ SQL ] SELECT `id`,`name`,`shortname`,`pinyin` FROM `bear_city` WHERE `leveltype` = 2 AND `status` = 1 [ RunTime:0.000212s ]
[ SQL ] SHOW COLUMNS FROM `bear_news` [ RunTime:0.001280s ]
[ SQL ] SELECT `id`,`school_id` FROM `bear_news` WHERE `id` = 34648 LIMIT 1 [ RunTime:0.000291s ]
[ SQL ] SHOW COLUMNS FROM `bear_school` [ RunTime:0.001530s ]
[ SQL ] SELECT `id`,`cityid` FROM `bear_school` WHERE `id` = 10006 AND `status` = 1 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `bear_city_config` WHERE `cityid` = 410300 LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] SELECT * FROM `bear_school` WHERE `id` = 10006 LIMIT 1 [ RunTime:0.000266s ]
[ SQL ] SHOW COLUMNS FROM `bear_service` [ RunTime:0.001275s ]
[ SQL ] SELECT * FROM `bear_service` WHERE `status` = 1 AND `cats` LIKE '%8%' LIMIT 1 [ RunTime:0.000227s ]
[ SQL ] SELECT * FROM `bear_school` WHERE `id` = 10006 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT * FROM `bear_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SELECT `id`,`name` FROM `bear_school` WHERE `name` LIKE '%德学教育%' AND `id` <> 10006 LIMIT 16 [ RunTime:0.000196s ]
[ SQL ] SELECT `id`,`name` FROM `bear_school` WHERE `first` = 8 AND `id` <> 10006 LIMIT 16 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `bear_category` WHERE `parent_id` = 8 LIMIT 16 [ RunTime:0.000206s ]
[ SQL ] SHOW COLUMNS FROM `bear_subcat` [ RunTime:0.001268s ]
[ SQL ] SELECT * FROM `bear_subcat` WHERE `school_id` = 10006 AND `type` = 'course' ORDER BY `id` [ RunTime:0.000245s ]
[ SQL ] SELECT * FROM `bear_city` WHERE `id` = 410300 LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SELECT * FROM `bear_city` WHERE `id` = 410000 LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SHOW COLUMNS FROM `bear_brance` [ RunTime:0.001289s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `bear_brance` WHERE `school_id` = 10006 LIMIT 1 [ RunTime:0.000209s ]
[ SQL ] SHOW COLUMNS FROM `bear_imglink` [ RunTime:0.001240s ]
[ SQL ] SELECT * FROM `bear_imglink` WHERE `cityid` = 410300 AND `status` = 1 [ RunTime:0.000218s ]
[ SQL ] SELECT * FROM `bear_brance` WHERE `school_id` = 10006 AND `status` = 1 ORDER BY `id` DESC [ RunTime:0.000211s ]
[ SQL ] SELECT `id`,`title`,`updatetime` FROM `bear_news` WHERE `school_id` = 10006 AND `status` = 1 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000328s ]
[ SQL ] SELECT `id`,`title`,`updatetime` FROM `bear_news` WHERE `school_id` = 10006 AND `status` = 1 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000226s ]
[ SQL ] SHOW COLUMNS FROM `bear_course` [ RunTime:0.001284s ]
[ SQL ] SELECT `id`,`title`,`content`,`image`,`views`,`updatetime` FROM `bear_course` WHERE `school_id` = 10006 AND `status` = '1' ORDER BY `id` DESC [ RunTime:0.009363s ]
[ SQL ] SHOW COLUMNS FROM `bear_album` [ RunTime:0.001268s ]
[ SQL ] SELECT `id`,`title`,`content`,`type`,`image`,`views`,`updatetime` FROM `bear_album` WHERE `school_id` = 10006 AND `status` = 1 ORDER BY `id` DESC [ RunTime:0.000236s ]
[ SQL ] SHOW COLUMNS FROM `bear_faq` [ RunTime:0.001252s ]
[ SQL ] SELECT `id`,`title`,`content`,`image`,`views`,`updatetime` FROM `bear_faq` WHERE `school_id` = 10006 AND `status` = 1 ORDER BY `id` DESC [ RunTime:0.000211s ]
[ SQL ] SHOW COLUMNS FROM `bear_piclink` [ RunTime:0.001216s ]
[ SQL ] SELECT * FROM `bear_piclink` WHERE `school_id` = 10006 [ RunTime:0.000198s ]
[ SQL ] SHOW COLUMNS FROM `bear_seo` [ RunTime:0.001259s ]
[ SQL ] SELECT * FROM `bear_seo` WHERE `school_id` = 10006 LIMIT 1 [ RunTime:0.000215s ]
[ SQL ] SELECT * FROM `bear_piclink` WHERE `status` = 1 [ RunTime:0.000260s ]
[ SQL ] SELECT SUM(views) AS tp_sum FROM `bear_school` WHERE `id` = 10006 LIMIT 1 [ RunTime:0.000216s ]
[ SQL ] SELECT SUM(views) AS tp_sum FROM `bear_course` WHERE `school_id` = 10006 LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT SUM(views) AS tp_sum FROM `bear_news` WHERE `school_id` = 10006 LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`school_id`,`title`,`image`,`content`,`updatetime`,`views` FROM `bear_news` WHERE `status` = 1 AND `id` = 34648 LIMIT 1 [ RunTime:0.000300s ]
[ SQL ] UPDATE `bear_news` SET `views`=`views`+1 WHERE `id` = 34648 [ RunTime:0.001275s ]
[ SQL ] SELECT `id`,`title` FROM `bear_news` WHERE `status` = 1 ORDER BY `views` DESC LIMIT 20 [ RunTime:0.113323s ]
[ SQL ] SELECT `id`,`title` FROM `bear_news` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000527s ]
[ SQL ] SELECT `id`,`title` FROM `bear_news` WHERE `school_id` = 10006 AND ( id>34648 ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000443s ]
[ SQL ] SELECT `id`,`title` FROM `bear_news` WHERE `school_id` = 10006 AND ( id<34648 ) AND `status` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `bear_school` WHERE `id` = 10006 LIMIT 1 [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `bear_school` WHERE `first` = 8 [ RunTime:0.001672s ]
[ SQL ] SELECT `id`,`title` FROM `bear_news` WHERE `school_id` IN (10002,10006,10025,10052,10057,10062,10065,10067,10077,10084,10089,10090,10096,10099,10102,10103,10105,10106,10111,10112,10113,10114,10117,10119,10120,10121,10122,10123,10124,10126,10127,10130,10131,10133,10134,10136) AND `status` = 1 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000473s ]