[ DB ] CONNECT:[ UseTime:0.000396s ] mysql:host=127.0.0.1;port=3306;dbname=ceshi_microsenso;charset=utf8
[ SQL ] SHOW COLUMNS FROM `qy_menu` [ RunTime:0.000994s ]
[ 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.001684s ]
[ SQL ] SHOW COLUMNS FROM `qy_featureclass` [ RunTime:0.000800s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '19' AND `state` = 1 [ RunTime:0.000411s ]
[ SQL ] SHOW COLUMNS FROM `qy_cp` [ RunTime:0.000805s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` = 20 AND `is_star` = 1 [ RunTime:0.000556s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '601' AND `state` = 1 [ RunTime:0.000399s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` = 602 AND `is_star` = 1 [ RunTime:0.000454s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '35' AND `state` = 1 [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '38' AND `state` = 1 [ RunTime:0.000338s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '72' AND `state` = 1 [ RunTime:0.000346s ]
[ 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.000534s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 36 AND `state` = 1 [ RunTime:0.000557s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 73 AND `state` = 1 [ RunTime:0.000489s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 82 AND `state` = 1 [ RunTime:0.000482s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 86 AND `state` = 1 [ RunTime:0.000514s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 104 AND `state` = 1 [ RunTime:0.000559s ]
[ SQL ] SELECT `goods_id`,`cpname`,`pic` FROM `qy_cp` WHERE `cateid` = 26 AND `is_star` = 1 LIMIT 1 [ RunTime:0.000436s ]
[ SQL ] SHOW COLUMNS FROM `qy_config` [ RunTime:0.000615s ]
[ SQL ] SHOW COLUMNS FROM `qy_links` [ RunTime:0.000701s ]
[ SQL ] SELECT `id`,`linksname`,`linkshref` FROM `qy_links` WHERE `state` = 1 AND `typeid` = 0 [ RunTime:0.000276s ]
[ SQL ] SHOW COLUMNS FROM `qy_blog` [ RunTime:0.000675s ]
[ SQL ] SELECT * FROM `qy_blog` WHERE `state` = '0' AND `id` = 19 LIMIT 1 [ RunTime:0.000317s ]
[ 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` = '19' LIMIT 1 [ RunTime:0.000370s ]
[ SQL ] SELECT * FROM `qy_blog` WHERE `id` > 19 AND `state` = '0' AND `cateid` IS NULL ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `qy_blog` WHERE `id` <19 AND `state` = '0' AND `cateid` IS NULL ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000290s ]
[ 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.001321s ]
[ SQL ] SHOW COLUMNS FROM `qy_blogcomment` [ RunTime:0.000651s ]
[ SQL ] SELECT * FROM `qy_blogcomment` WHERE `blog_id` = 19 AND `status` = 1 [ RunTime:0.000325s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blogcomment` WHERE `blog_id` = 19 AND `status` = 1 LIMIT 1 [ RunTime:0.000300s ]
[ SQL ] SHOW COLUMNS FROM `qy_blogcategories` [ RunTime:0.000615s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blogcategories` LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] SELECT `id`,`cate_name` FROM `qy_blogcategories` [ RunTime:0.000235s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blog` WHERE `cateid` = 1 AND `state` = '0' LIMIT 1 [ RunTime:0.000546s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blog` WHERE `cateid` = 3 AND `state` = '0' LIMIT 1 [ RunTime:0.000482s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qy_blog` WHERE `cateid` = 5 AND `state` = '0' LIMIT 1 [ RunTime:0.000443s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 601 AND `state` = 1 ORDER BY `sort` ASC [ RunTime:0.000555s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 19 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000708s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 20 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000581s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 22 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000582s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 23 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000595s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 113 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000549s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 25 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000621s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 108 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000550s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 26 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000477s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '20' AND `state` = 1 [ RunTime:0.000342s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '22' AND `state` = 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '23' AND `state` = 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '113' AND `state` = 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '25' AND `state` = 1 [ RunTime:0.000337s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '108' AND `state` = 1 [ RunTime:0.000342s ]
[ SQL ] SELECT * FROM `qy_featureclass` WHERE `cateid` = '26' AND `state` = 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 20 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000557s ]
[ 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.000447s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 22 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000577s ]
[ 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.000414s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 23 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000590s ]
[ 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.000405s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 113 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000522s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (113,637,638) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000382s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 25 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000617s ]
[ 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.000453s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 108 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000493s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (108,109) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000450s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 26 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000516s ]
[ SQL ] SELECT `goods_id`,`cpname`,`urlname`,`pic` FROM `qy_cp` WHERE `cateid` IN (26,661) AND `is_star` = 1 LIMIT 1 [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 602 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000501s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 603 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 604 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000535s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 605 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000564s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 606 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000506s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 607 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000521s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 608 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000498s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 609 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000570s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 602 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000495s ]
[ SQL ] SHOW COLUMNS FROM `qy_industres` [ RunTime:0.000719s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (602,610,611) AND `hot` = 1 LIMIT 2 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 603 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000496s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (603,619) AND `hot` = 1 LIMIT 2 [ RunTime:0.000355s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 604 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (604,672,643) AND `hot` = 1 LIMIT 2 [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 605 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000549s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (605,612,613,614,644,646) AND `hot` = 1 LIMIT 2 [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 606 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000503s ]
[ 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.000496s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (607,615,648) AND `hot` = 1 LIMIT 2 [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 608 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (608,649) AND `hot` = 1 LIMIT 2 [ RunTime:0.000357s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 609 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000553s ]
[ SQL ] SELECT * FROM `qy_industres` WHERE `cate` IN (609,616,617,618,655,656,657,658) AND `hot` = 1 LIMIT 2 [ RunTime:0.000389s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 38 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000544s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 110 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000511s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 36 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000513s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 67 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 68 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 601 AND `state` = 1 ORDER BY `sort` ASC [ RunTime:0.000636s ]
[ SQL ] SELECT * FROM `qy_menu` WHERE `pid` = 19 AND `state` = 1 ORDER BY `sort` DESC [ RunTime:0.000675s ]
0條評論:
發表評論