SHOW FULL COLUMNS FROM `t_sys` [ RunTime:0.003311s ]
SELECT * FROM `t_sys` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000362s ]
SELECT `ip` FROM `t_sys` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000176s ]
SELECT `is_baidu` FROM `t_sys` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000149s ]
SELECT `area` FROM `t_sys` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000123s ]
SHOW FULL COLUMNS FROM `t_user` [ RunTime:0.002630s ]
SELECT * FROM `t_user` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000188s ]
SELECT * FROM `t_sys` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000251s ]
SELECT * FROM `t_user` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000187s ]
SELECT * FROM `t_sys` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `t_pages_cate` [ RunTime:0.002395s ]
SELECT * FROM `t_pages_cate` [ RunTime:0.000146s ]
SHOW FULL COLUMNS FROM `t_article` [ RunTime:0.002424s ]
SELECT * FROM `t_article` ORDER BY `id` DESC LIMIT 12 [ RunTime:0.000209s ]
SELECT * FROM `t_user` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000185s ]
SELECT * FROM `t_user` ORDER BY `create_time` DESC,`id` DESC LIMIT 20 [ RunTime:0.000196s ]
SELECT * FROM `t_user` ORDER BY `create_time` DESC,`id` DESC LIMIT 200 [ RunTime:0.000225s ]
SELECT * FROM `t_user` WHERE `type` IN (1,2,3) AND `checked` = 1 AND `truename` <> '' AND `nl` <> '' AND `sf` <> '' AND `city` <> '' AND `height` <> '' AND `qq_number` <> '' AND `wechat_number` <> '' ORDER BY `id` DESC LIMIT 4 [ RunTime:0.000240s ]
SHOW FULL COLUMNS FROM `t_city` [ RunTime:0.002425s ]
SELECT * FROM `t_city` WHERE `topid` = 0 [ RunTime:0.000182s ]
SELECT * FROM `t_city` WHERE `topid` > 0 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `t_cate_yj` [ RunTime:0.002445s ]
SELECT * FROM `t_cate_yj` WHERE `status` = 0 AND `content` IS NOT NULL ORDER BY `create_time` DESC LIMIT 40 [ RunTime:0.000450s ]
SHOW FULL COLUMNS FROM `t_cate_qa` [ RunTime:0.002591s ]
SELECT * FROM `t_cate_qa` WHERE `status` = 0 AND `content` IS NOT NULL ORDER BY `create_time` DESC LIMIT 10 [ RunTime:0.016466s ]
SHOW FULL COLUMNS FROM `t_cate_qa1` [ RunTime:0.002564s ]
SELECT * FROM `t_cate_qa1` WHERE `status` = 0 AND `content` IS NOT NULL ORDER BY `create_time` DESC LIMIT 10 [ RunTime:0.022082s ]
SHOW FULL COLUMNS FROM `t_cate_comment` [ RunTime:0.002950s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27450 [ RunTime:0.000185s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27449 [ RunTime:0.000156s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27448 [ RunTime:0.000150s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27447 [ RunTime:0.000148s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27446 [ RunTime:0.000148s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27445 [ RunTime:0.000161s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27444 [ RunTime:0.000143s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27443 [ RunTime:0.000150s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27442 [ RunTime:0.000148s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 27441 [ RunTime:0.000147s ]
SHOW FULL COLUMNS FROM `t_cate_qa2` [ RunTime:0.002444s ]
SELECT * FROM `t_cate_qa2` WHERE `status` = 0 AND `content` IS NOT NULL ORDER BY `create_time` DESC LIMIT 10 [ RunTime:0.024264s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30716 [ RunTime:0.000203s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30715 [ RunTime:0.000162s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30714 [ RunTime:0.000151s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30713 [ RunTime:0.000149s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30712 [ RunTime:0.000147s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30711 [ RunTime:0.000162s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30710 [ RunTime:0.000189s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30709 [ RunTime:0.000149s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30708 [ RunTime:0.000148s ]
SELECT COUNT(*) AS think_count FROM `t_cate_comment` WHERE `pid` = 30707 [ RunTime:0.000149s ]
SHOW FULL COLUMNS FROM `t_scenery` [ RunTime:0.002474s ]
SELECT * FROM `t_scenery` ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `t_scenery_cate` [ RunTime:0.002962s ]
SELECT * FROM `t_scenery_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000157s ]
SELECT * FROM `t_scenery_cate` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000179s ]
SHOW FULL COLUMNS FROM `t_scenery_dz` [ RunTime:0.002258s ]
SELECT * FROM `t_scenery_dz` ORDER BY `id` DESC LIMIT 200 [ RunTime:0.000171s ]
SELECT * FROM `t_scenery` WHERE `id` = 25799 LIMIT 1 [ RunTime:0.000250s ]
SELECT * FROM `t_scenery` WHERE `id` = 40425 LIMIT 1 [ RunTime:0.000243s ]
SELECT * FROM `t_scenery` WHERE `id` = 40773 LIMIT 1 [ RunTime:0.000226s ]
SELECT * FROM `t_scenery` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `t_scenery` WHERE `id` = -5 LIMIT 1 [ RunTime:0.000156s ]
SELECT * FROM `t_scenery` WHERE `id` = -1 LIMIT 1 [ RunTime:0.000156s ]
SELECT * FROM `t_scenery` WHERE `id` = 2147483647 LIMIT 1 [ RunTime:0.000139s ]
SELECT * FROM `t_scenery` WHERE `id` = 12345 LIMIT 1 [ RunTime:0.000209s ]
SELECT * FROM `t_scenery_cate` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000168s ]
SELECT * FROM `t_scenery_cate` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000149s ]
SELECT * FROM `t_scenery_cate` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000154s ]
SELECT * FROM `t_scenery_cate` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000151s ]
SELECT * FROM `t_scenery` WHERE `id` = 21739 LIMIT 1 [ RunTime:0.000246s ]
SELECT * FROM `t_scenery_cate` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000208s ]
UPDATE `t_scenery` SET `pv` = `pv` + 1 WHERE `id` = 21739 [ RunTime:0.000321s ]
SELECT COUNT(*) AS think_count FROM `t_scenery_dz` WHERE `tour_id` = 21739 [ RunTime:0.000307s ]
SELECT `id`,`name`,`pv`,`cateid`,`img` FROM `t_scenery` WHERE `cateid` = 31 ORDER BY `pv` DESC LIMIT 30 [ RunTime:0.017156s ]
SELECT * FROM `t_cate_qa` WHERE `title` LIKE '%温州凤湖主题公园%' ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.026025s ]
SELECT * FROM `t_cate_qa2` WHERE `title` LIKE '%温州凤湖主题公园%' ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.037341s ]