SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001145s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 199998 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 199998 [ RunTime:0.001967s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.001843s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '199998' AND `j`.`switch` = '1' [ RunTime:0.003843s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001195s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('完','帐') AND `switch` = 1 [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.001356s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '完帐' AND `switch` = 1 LIMIT 1 [ RunTime:0.001012s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('结账','结算','清账','结清','结账收款','挂账','未结账','未清账') AND `switch` = 1 [ RunTime:0.000392s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` > 199998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (38316,219241,106303,69848,205816,49743,223432,205929,175061,245109,120141,229919,63301,137740,150978,204631,228493,70870,40938,173886,62546,88330,61525,36055,242874,122282,124136,66886,127874,122445,225640,61902,194333,37166,197399,20148,115336,167700,162908,217458) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.002401s ]