[ DB ] CONNECT:[ UseTime:0.022487s ] mysql:host=172.21.0.15;port=3306;dbname=gczb;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `zb_info` [ RunTime:0.005476s ]
[ SQL ] SELECT * FROM `zb_info` WHERE ( nid=427082913 and status=1 and postuser not in(472,474) ) [ RunTime:0.000757s ]
[ SQL ] SHOW COLUMNS FROM `zb_replace` [ RunTime:0.016204s ]
[ SQL ] SELECT * FROM `zb_replace` WHERE ( status=1 ) ORDER BY `sort` DESC [ RunTime:0.004671s ]
[ SQL ] SHOW COLUMNS FROM `zb_infomation` [ RunTime:0.005009s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.000734s ]
[ SQL ] SHOW COLUMNS FROM `zb_city` [ RunTime:0.001555s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE ( cityid in(142,152) ) [ RunTime:0.000717s ]
[ SQL ] SELECT `cityname` FROM `zb_city` WHERE `cityid` = 152 LIMIT 1 [ RunTime:0.014249s ]
[ SQL ] SHOW COLUMNS FROM `zb_sys_keyword` [ RunTime:0.001873s ]
[ 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.003907s ]
[ 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.007582s ]
[ SQL ] SELECT `id`,`title` FROM `zb_sys_keyword` WHERE ( parentid=623 and status=1 and find_in_set('chinabidding',source) ) [ RunTime:0.004060s ]
[ SQL ] SHOW COLUMNS FROM `zb_sys_keyword_group` [ RunTime:0.007445s ]
[ 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.002767s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE `parentid` = 142 [ RunTime:0.007976s ]
[ SQL ] SELECT `cityid`,`cityname`,`en_name` FROM `zb_city` WHERE ( parentid=0 ) ORDER BY `cityid` ASC [ RunTime:0.002601s ]
[ 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.001299s ]
[ SQL ] SHOW COLUMNS FROM `zb_keyword` [ RunTime:0.001726s ]
[ SQL ] SELECT * FROM `zb_keyword` WHERE ( status =1 ) ORDER BY `sort` DESC LIMIT 13 [ RunTime:0.000837s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE ( parentid=0 ) ORDER BY `cityid` ASC [ RunTime:0.002640s ]
[ SQL ] SHOW COLUMNS FROM `zb_ads` [ RunTime:0.015142s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=138 and status=1 ) ORDER BY `sort` DESC [ RunTime:0.001257s ]
[ SQL ] SELECT `infoid`,`parentid` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.000763s ]
[ SQL ] SELECT `infoid`,`parentid` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.005553s ]
[ SQL ] SELECT `infoid`,`parentid` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.002171s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (1) ) [ RunTime:0.007915s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.000825s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (9) ) [ RunTime:0.004371s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE ( cityid in (142) ) [ RunTime:0.000676s ]
[ 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.018166s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=121 and status=1 ) ORDER BY `sort` DESC,`posttime` DESC [ RunTime:0.013279s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=140 and status=1 ) ORDER BY `sort` DESC,`posttime` DESC [ RunTime:0.001020s ]