SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 643404 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 643404 [ RunTime:0.002238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023341,693881,109505,625694,701800,165090,676609,145059,179932,851047,427879,422889,962422,405140,89507,494023,146765,230437,324142,431368,501165,205364,883341,752307,436827,74665,889739,520472,492486,654488,875091,111093,953924,159852,680178,225740,31827,593854,747848,266930,865138,546307,198291,532191,17438,1038026,328532,388091,216561,791767,935154,747809,990423,830755,1036146,849014,904231,900448,979750,963929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 643404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 643404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]