SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.002032s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 117923 LIMIT 1 [ RunTime:0.003324s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 117923 [ RunTime:0.005647s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.001921s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '117923' AND `j`.`switch` = '1' [ RunTime:0.009335s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.002710s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('山','堂','香','水') AND `switch` = 1 [ RunTime:0.003626s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.001735s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '山堂香水' AND `switch` = 1 LIMIT 1 [ RunTime:0.001969s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('山堂芳香','山香','山堂香气','山堂幽香','无香','淡香') AND `switch` = 1 [ RunTime:0.010835s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (93015,150993,190048,183766,175975,225704,205395,233187,49807,69801,156395,114348,237805,228398,81720,46696,95708,87909,252998,194057,50624,242951,147437,214931,253510,14959,37787,7447,14788,207877,127115,101186,39935,172043,143705,155933,247596,184322,172581,248241) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.044052s ]