[ DB ] CONNECT:[ UseTime:0.002963s ] mysql:host=172.21.0.15;port=3306;dbname=gczb;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `zb_infomation` [ RunTime:0.001956s ]
[ SQL ] SELECT * FROM `zb_infomation` WHERE ( parentid=0 and status=1 and `show`=1 ) [ RunTime:0.000897s ]
[ SQL ] SHOW COLUMNS FROM `zb_info` [ RunTime:0.001874s ]
[ SQL ] SELECT * FROM `zb_info` WHERE ( nid=450113261 and status=1 and postuser not in(472,474) ) [ RunTime:0.000842s ]
[ SQL ] SHOW COLUMNS FROM `zb_replace` [ RunTime:0.001730s ]
[ SQL ] SELECT * FROM `zb_replace` WHERE ( status=1 ) ORDER BY `sort` DESC [ RunTime:0.001267s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (29) ) [ RunTime:0.000690s ]
[ SQL ] SHOW COLUMNS FROM `zb_city` [ RunTime:0.001687s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE ( cityid in(79,92) ) [ RunTime:0.000603s ]
[ SQL ] SELECT `cityname` FROM `zb_city` WHERE `cityid` = 92 LIMIT 1 [ RunTime:0.000766s ]
[ SQL ] SHOW COLUMNS FROM `zb_sys_keyword` [ RunTime:0.001700s ]
[ 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.003862s ]
[ 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.007927s ]
[ SQL ] SELECT `id`,`title` FROM `zb_sys_keyword` WHERE ( parentid=623 and status=1 and find_in_set('chinabidding',source) ) [ RunTime:0.002988s ]
[ SQL ] SHOW COLUMNS FROM `zb_sys_keyword_group` [ RunTime:0.001683s ]
[ 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.000747s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE `parentid` = 79 [ RunTime:0.002265s ]
[ SQL ] SELECT `cityid`,`cityname`,`en_name` FROM `zb_city` WHERE ( parentid=0 ) ORDER BY `cityid` ASC [ RunTime:0.002512s ]
[ 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.001217s ]
[ SQL ] SHOW COLUMNS FROM `zb_keyword` [ RunTime:0.001669s ]
[ SQL ] SELECT * FROM `zb_keyword` WHERE ( status =1 ) ORDER BY `sort` DESC LIMIT 13 [ RunTime:0.000943s ]
[ SQL ] SELECT `cityid`,`cityname` FROM `zb_city` WHERE ( parentid=0 ) ORDER BY `cityid` ASC [ RunTime:0.002208s ]
[ SQL ] SHOW COLUMNS FROM `zb_ads` [ RunTime:0.001553s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=138 and status=1 ) ORDER BY `sort` DESC [ RunTime:0.000997s ]
[ SQL ] SELECT `infoid`,`parentid` FROM `zb_infomation` WHERE ( infoid in (29) ) [ RunTime:0.000618s ]
[ SQL ] SELECT `infoid`,`parentid` FROM `zb_infomation` WHERE ( infoid in (29) ) [ RunTime:0.000636s ]
[ SQL ] SELECT `infoid`,`parentid` FROM `zb_infomation` WHERE ( infoid in (29) ) [ RunTime:0.000574s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (3) ) [ RunTime:0.000616s ]
[ SQL ] SELECT `infoid`,`infoname` FROM `zb_infomation` WHERE ( infoid in (29) ) [ RunTime:0.000680s ]
[ SQL ] SHOW COLUMNS FROM `zb_classlist` [ RunTime:0.001375s ]
[ SQL ] SELECT `classid`,`classname` FROM `zb_classlist` WHERE ( classid in (11) ) [ RunTime:0.000609s ]
[ SQL ] SELECT `classid`,`classname` FROM `zb_classlist` WHERE ( classid in (26) ) [ RunTime:0.000592s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=120 and status=1 ) ORDER BY `sort` DESC,`posttime` DESC [ RunTime:0.001005s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=121 and status=1 ) ORDER BY `sort` DESC,`posttime` DESC [ RunTime:0.000924s ]
[ SQL ] SELECT * FROM `zb_ads` WHERE ( classid=140 and status=1 ) ORDER BY `sort` DESC,`posttime` DESC [ RunTime:0.000895s ]