SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001162s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 47871 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 47871 [ RunTime:0.002338s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.001480s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '47871' AND `j`.`switch` = '1' [ RunTime:0.003493s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001159s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('边','馆') AND `switch` = 1 [ RunTime:0.001069s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.000935s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '边馆' AND `switch` = 1 LIMIT 1 [ RunTime:0.001577s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('客栈','旅馆','客店','酒店','客房','无') AND `switch` = 1 [ RunTime:0.003897s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (121676,27297,98813,130798,213097,141237,152711,123487,93005,88505,147379,252258,54732,224146,241178,103735,138570,68860,159413,57561,213519,153751,22575,150221,30966,28664,160816,249770,132686,178687,72319,101446,58201,67257,31604,159958,150516,183748,225350,142054) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.002045s ]