[ DB ] CONNECT:[ UseTime:0.000417s ] mysql:host=127.0.0.1;port=3306;dbname=ceshi_microsenso;charset=utf8
[ SQL ] SHOW COLUMNS FROM `qy_menu` [ RunTime:0.001002s ]
[ SQL ] SELECT `id`,`name`,`url_mark`,`pid`,`type`,`menuvalue`,`menualign` FROM `qy_menu` WHERE `state` = 1 AND `menualign` NOT LIKE '%2%' ORDER BY `sort` DESC [ RunTime:0.001556s ]
[ SQL ] SHOW COLUMNS FROM `qy_featureclass` [ RunTime:0.000995s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '19' AND `state` = 1 [ RunTime:0.000432s ]
[ SQL ] SHOW COLUMNS FROM `qy_cp` [ RunTime:0.000846s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` = 20 AND `is_star` = 1 [ RunTime:0.000513s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '601' AND `state` = 1 [ RunTime:0.000436s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` = 602 AND `is_star` = 1 [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '35' AND `state` = 1 [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '38' AND `state` = 1 [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '72' AND `state` = 1 [ RunTime:0.000389s ]
[ SQL ] SELECT `id`,`name`,`url_mark`,`pid`,`type`,`menuvalue` FROM `qy_menu` WHERE `state` = 1 AND `menualign` LIKE '%1%' ORDER BY `sort` DESC [ RunTime:0.000550s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 36 AND `state` = 1 [ RunTime:0.000540s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 73 AND `state` = 1 [ RunTime:0.000513s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 82 AND `state` = 1 [ RunTime:0.000517s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 86 AND `state` = 1 [ RunTime:0.000521s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 104 AND `state` = 1 [ RunTime:0.000533s ]
[ SQL ] SELECT `goods_id`,`cpname`,`pic` FROM `qy_cp` WHERE `cateid` = 26 AND `is_star` = 1 LIMIT 1 [ RunTime:0.000490s ]
[ SQL ] SHOW COLUMNS FROM `qy_config` [ RunTime:0.000646s ]
[ SQL ] SHOW COLUMNS FROM `qy_links` [ RunTime:0.000691s ]
[ SQL ] SELECT `id`,`linksname`,`linkshref` FROM `qy_links` WHERE `state` = 1 AND `typeid` = 0 [ RunTime:0.000279s ]
[ SQL ] SHOW COLUMNS FROM `qy_blog` [ RunTime:0.000728s ]
[ SQL ] SELECT * FROM `qy_blog` WHERE `state` = '0' AND `id` = 15 LIMIT 1 [ RunTime:0.000344s ]
[ SQL ] SELECT `a`.*,`b`.`cate_name`,`c`.`account` FROM `qy_blog` `a` INNER JOIN `qy_blogcategories` `b` ON `b`.`id`=`a`.`cateid` INNER JOIN `qy_manager` `c` ON `c`.`id`=`a`.`author` WHERE `a`.`state` = 0 AND `a`.`id` = '15' LIMIT 1 [ RunTime:0.000351s ]
[ SQL ] SELECT * FROM `qy_blog` WHERE `id` > 15 AND `state` = '0' AND `cateid` IS NULL ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `qy_blog` WHERE `id` <15 AND `state` = '0' AND `cateid` IS NULL ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SELECT `a`.*,`b`.`cate_name` FROM `qy_blog` `a` INNER JOIN `qy_blogcategories` `b` ON `b`.`id`=`a`.`cateid` WHERE `a`.`state` = 0 ORDER BY `click` DESC LIMIT 5 [ RunTime:0.001288s ]
[ SQL ] SHOW COLUMNS FROM `qy_blogcomment` [ RunTime:0.000702s ]
[ SQL ] SELECT * FROM `qy_blogcomment` WHERE `blog_id` = 15 AND `status` = 1 [ RunTime:0.000292s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blogcomment` WHERE `blog_id` = 15 AND `status` = 1 LIMIT 1 [ RunTime:0.000319s ]
[ SQL ] SHOW COLUMNS FROM `qy_blogcategories` [ RunTime:0.000648s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blogcategories` LIMIT 1 [ RunTime:0.000206s ]
[ SQL ] SELECT `id`,`cate_name` FROM `qy_blogcategories` [ RunTime:0.000214s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blog` WHERE `cateid` = 1 AND `state` = '0' LIMIT 1 [ RunTime:0.000527s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blog` WHERE `cateid` = 3 AND `state` = '0' LIMIT 1 [ RunTime:0.000507s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blog` WHERE `cateid` = 5 AND `state` = '0' LIMIT 1 [ RunTime:0.000459s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 601 AND `state` = 1 ORDER BY `sort` ASC [ RunTime:0.000585s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 19 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000713s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 20 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000589s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 22 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000581s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 23 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000560s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 113 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 25 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000611s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 108 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000517s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 26 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '20' AND `state` = 1 [ RunTime:0.000350s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '22' AND `state` = 1 [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '23' AND `state` = 1 [ RunTime:0.000338s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '113' AND `state` = 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '25' AND `state` = 1 [ RunTime:0.000330s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '108' AND `state` = 1 [ RunTime:0.000329s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '26' AND `state` = 1 [ RunTime:0.000328s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 20 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000570s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (20,620,621,622,623,624,625) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000463s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 22 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000601s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (22,626,31,628,640,641,630,666) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 23 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000576s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (23,631,632,633,634,635,636) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000382s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 113 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000494s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (113,637,638) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000373s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 25 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000610s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (25,27,115,116,117,118,119,662,663,664,665) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 108 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000509s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (108,109) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000435s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 26 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000493s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (26,661) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 602 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000490s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 603 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000508s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 604 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 605 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000548s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 606 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000497s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 607 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000491s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 608 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000531s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 609 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000549s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 602 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000532s ]
[ SQL ] SHOW COLUMNS FROM `qy_industres` [ RunTime:0.000697s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (602,610,611) AND `hot` = 1 LIMIT 2 [ RunTime:0.000357s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 603 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000498s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (603,619) AND `hot` = 1 LIMIT 2 [ RunTime:0.000378s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 604 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000477s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (604,672,643) AND `hot` = 1 LIMIT 2 [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 605 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000569s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (605,612,613,614,644,646) AND `hot` = 1 LIMIT 2 [ RunTime:0.000352s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 606 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (606,647) AND `hot` = 1 LIMIT 2 [ RunTime:0.000371s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 607 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000520s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (607,615,648) AND `hot` = 1 LIMIT 2 [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 608 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000528s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (608,649) AND `hot` = 1 LIMIT 2 [ RunTime:0.000392s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 609 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000527s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (609,616,617,618,655,656,657,658) AND `hot` = 1 LIMIT 2 [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 38 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000523s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 110 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 36 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000486s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 67 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000501s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 68 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000529s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 601 AND `state` = 1 ORDER BY `sort` ASC [ RunTime:0.000612s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 19 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000690s ]
0條評論:
發表評論