[ DB ] CONNECT:[ UseTime:0.000404s ] mysql:host=127.0.0.1;port=3306;dbname=ceshi_microsenso;charset=utf8
[ SQL ] SHOW COLUMNS FROM `qy_menu` [ RunTime:0.001015s ]
[ 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.001537s ]
[ SQL ] SHOW COLUMNS FROM `qy_featureclass` [ RunTime:0.000857s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '19' AND `state` = 1 [ RunTime:0.000422s ]
[ SQL ] SHOW COLUMNS FROM `qy_cp` [ RunTime:0.000810s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` = 20 AND `is_star` = 1 [ RunTime:0.000545s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '601' AND `state` = 1 [ RunTime:0.000361s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` = 602 AND `is_star` = 1 [ RunTime:0.000467s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '35' AND `state` = 1 [ RunTime:0.000368s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '38' AND `state` = 1 [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '72' AND `state` = 1 [ RunTime:0.000366s ]
[ 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.000547s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 36 AND `state` = 1 [ RunTime:0.000508s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 73 AND `state` = 1 [ RunTime:0.000493s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 82 AND `state` = 1 [ RunTime:0.000518s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 86 AND `state` = 1 [ RunTime:0.000505s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 104 AND `state` = 1 [ RunTime:0.000564s ]
[ SQL ] SELECT `goods_id`,`cpname`,`pic` FROM `qy_cp` WHERE `cateid` = 26 AND `is_star` = 1 LIMIT 1 [ RunTime:0.000426s ]
[ SQL ] SHOW COLUMNS FROM `qy_config` [ RunTime:0.000660s ]
[ SQL ] SHOW COLUMNS FROM `qy_links` [ RunTime:0.000642s ]
[ SQL ] SELECT `id`,`linksname`,`linkshref` FROM `qy_links` WHERE `state` = 1 AND `typeid` = 0 [ RunTime:0.000304s ]
[ SQL ] SHOW COLUMNS FROM `qy_blog` [ RunTime:0.000725s ]
[ SQL ] SELECT * FROM `qy_blog` WHERE `state` = '0' AND `id` = 38 LIMIT 1 [ RunTime:0.000364s ]
[ 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` = '38' LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `qy_blog` WHERE `id` > 38 AND `state` = '0' AND `cateid` IS NULL ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `qy_blog` WHERE `id` <38 AND `state` = '0' AND `cateid` IS NULL ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000306s ]
[ 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.001299s ]
[ SQL ] SHOW COLUMNS FROM `qy_blogcomment` [ RunTime:0.000687s ]
[ SQL ] SELECT * FROM `qy_blogcomment` WHERE `blog_id` = 38 AND `status` = 1 [ RunTime:0.000312s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blogcomment` WHERE `blog_id` = 38 AND `status` = 1 LIMIT 1 [ RunTime:0.000288s ]
[ SQL ] SHOW COLUMNS FROM `qy_blogcategories` [ RunTime:0.000668s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blogcategories` LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SELECT `id`,`cate_name` FROM `qy_blogcategories` [ RunTime:0.000221s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blog` WHERE `cateid` = 1 AND `state` = '0' LIMIT 1 [ RunTime:0.000525s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blog` WHERE `cateid` = 3 AND `state` = '0' LIMIT 1 [ RunTime:0.000505s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blog` WHERE `cateid` = 5 AND `state` = '0' LIMIT 1 [ RunTime:0.000471s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 601 AND `state` = 1 ORDER BY `sort` ASC [ RunTime:0.000580s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 19 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000688s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 20 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000593s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 22 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000569s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 23 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000577s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 113 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000539s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 25 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000601s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 108 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000543s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 26 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000473s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '20' AND `state` = 1 [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '22' AND `state` = 1 [ RunTime:0.000342s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '23' AND `state` = 1 [ RunTime:0.000333s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '113' AND `state` = 1 [ RunTime:0.000374s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '25' AND `state` = 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '108' AND `state` = 1 [ RunTime:0.000417s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '26' AND `state` = 1 [ RunTime:0.000331s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 20 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000560s ]
[ 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.000449s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 22 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000576s ]
[ 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.000412s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 23 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000567s ]
[ 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.000359s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 113 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000489s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (113,637,638) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000384s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 25 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000619s ]
[ 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.000474s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 108 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000476s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (108,109) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000496s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 26 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000515s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (26,661) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000418s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 602 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000525s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 603 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000502s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 604 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000541s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 605 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000547s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 606 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 607 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 608 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000529s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 609 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000551s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 602 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000522s ]
[ SQL ] SHOW COLUMNS FROM `qy_industres` [ RunTime:0.000704s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (602,610,611) AND `hot` = 1 LIMIT 2 [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 603 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000493s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (603,619) AND `hot` = 1 LIMIT 2 [ RunTime:0.000372s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 604 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000509s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (604,672,643) AND `hot` = 1 LIMIT 2 [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 605 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000563s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (605,612,613,614,644,646) AND `hot` = 1 LIMIT 2 [ RunTime:0.000348s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 606 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (606,647) AND `hot` = 1 LIMIT 2 [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 607 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000514s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (607,615,648) AND `hot` = 1 LIMIT 2 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 608 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000510s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (608,649) AND `hot` = 1 LIMIT 2 [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 609 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000531s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (609,616,617,618,655,656,657,658) AND `hot` = 1 LIMIT 2 [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 38 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 110 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000544s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 36 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 67 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000506s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 68 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 601 AND `state` = 1 ORDER BY `sort` ASC [ RunTime:0.000599s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 19 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000714s ]
0條評論:
發表評論