[ DB ] CONNECT:[ UseTime:0.006158s ] mysql:host=172.21.0.15;port=3306;dbname=gczb;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `zb_info` [ RunTime:0.013091s ]
[ SQL ] SELECT * FROM `zb_info` WHERE ( nid=417129725 and status=1 and postuser not in(472,474) ) [ RunTime:0.001161s ]
[ SQL ] SHOW COLUMNS FROM `zb_replace` [ RunTime:0.001771s ]
[ SQL ] SELECT * FROM `zb_replace` WHERE ( status=1 ) ORDER BY `sort` DESC [ RunTime:0.001194s ]
[ SQL ] SHOW COLUMNS FROM `zb_infomation` [ RunTime:0.013487s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.004300s ]
[ SQL ] SHOW COLUMNS FROM `zb_city` [ RunTime:0.001559s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE ( cityid in(154,161) ) [ RunTime:0.000671s ]
[ SQL ] SELECT `cityname` FROM `zb_city` WHERE `cityid` = 161 LIMIT 1 [ RunTime:0.003257s ]
[ SQL ] SHOW COLUMNS FROM `zb_sys_keyword` [ RunTime:0.001615s ]
[ SQL ] SELECT `s2`.`id` FROM `zb_sys_keyword` `s1` INNER JOIN `zb_sys_keyword` `s2` ON `s1`.`id`=`s2`.`parentid` WHERE ( s1.parentid=1 and s1.status=1 and s2.status=1 and s1.id!=20 ) [ RunTime:0.004130s ]
[ SQL ] SELECT `id`,`title` FROM `zb_sys_keyword` WHERE `parentid` IN (165,166,167,202,203,204,231,233,235,290,291,293,298,299,301,342,343,345,380,382,384,425,426,427,461,462,463,503,504,507,509,511,562,565,773,810,811,812,813,1044,1045,1294,1407,1435,1495,1496,1497,1498,1851,1852,2034,2190,2191,2192,2193,2194,2195,2196,2198,2199,2581,2582,2584,2769,2770,2771,2772,2965,2966,2967,2968,3127,3128,3129,3130,3131,3132,3133,3221,3222,3223,3224,3289,3290,3291,3292,3293,3294,3580,3581,3582,3583,3584,3585) ORDER BY rand() LIMIT 40 [ RunTime:0.007863s ]
[ SQL ] SELECT `id`,`title` FROM `zb_sys_keyword` WHERE ( parentid=623 and status=1 and find_in_set('chinabidding',source) ) [ RunTime:0.003030s ]
[ SQL ] SHOW COLUMNS FROM `zb_sys_keyword_group` [ RunTime:0.001805s ]
[ SQL ] SELECT * FROM `zb_sys_keyword_group` WHERE ( status=1 and find_in_set('chinabidding',source) and id=5 ) ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000797s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE `parentid` = 154 [ RunTime:0.002268s ]
[ SQL ] SELECT `cityid`,`cityname`,`en_name` FROM `zb_city` WHERE ( parentid=0 ) ORDER BY `cityid` ASC [ RunTime:0.002495s ]
[ SQL ] SELECT * FROM `zb_infomation` WHERE ( status=1 and show_select=1 and find_in_set('chinabidding',source) ) ORDER BY `sort` DESC,`infoid` ASC [ RunTime:0.007175s ]
[ SQL ] SHOW COLUMNS FROM `zb_keyword` [ RunTime:0.001644s ]
[ SQL ] SELECT * FROM `zb_keyword` WHERE ( status =1 ) ORDER BY `sort` DESC LIMIT 13 [ RunTime:0.002413s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE ( parentid=0 ) ORDER BY `cityid` ASC [ RunTime:0.002250s ]
[ SQL ] SHOW COLUMNS FROM `zb_ads` [ RunTime:0.001617s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=138 and status=1 ) ORDER BY `sort` DESC [ RunTime:0.000942s ]
[ SQL ] SELECT `infoid`,`parentid` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.000636s ]
[ SQL ] SELECT `infoid`,`parentid` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.000612s ]
[ SQL ] SELECT `infoid`,`parentid` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.000628s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (1) ) [ RunTime:0.000594s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.000594s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.000609s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE ( cityid in (154) ) [ RunTime:0.000596s ]
[ SQL ] SELECT * FROM `zb_replace` WHERE ( status=1 ) ORDER BY `sort` DESC [ RunTime:0.001179s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=120 and status=1 ) ORDER BY `sort` DESC,`posttime` DESC [ RunTime:0.001088s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=121 and status=1 ) ORDER BY `sort` DESC,`posttime` DESC [ RunTime:0.000903s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=140 and status=1 ) ORDER BY `sort` DESC,`posttime` DESC [ RunTime:0.000919s ]