SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199594 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199594 [ RunTime:0.009515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825951,455707,103955,165167,159308,905593,388751,867683,389590,150577,915518,634079,54537,429268,446594,743092,900427,137408,455165,616725,1001211,969561,34421,200615,226550,277500,725811,509910,503519,17441,710085,147568,1038011,105298,519935,157458,108415,172001,756072,774848,418730,701278,1037313,283763,812572,227948,915428,95065,310807,525894,1017923,211899,1004807,981372,404068,423823,1044489,251546,20066,168467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]