SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438526 LIMIT 1 [ RunTime:0.001062s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438526 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602997,1024724,74457,935620,366131,1014376,661796,710987,119276,858972,61097,998792,349670,746780,418255,330428,89742,401987,893009,380582,173519,219986,536642,524588,441766,806732,406951,391257,860309,932527,664397,936464,454491,296095,965098,680475,216343,714842,140112,922406,52717,109636,605529,536247,646245,774298,408630,718779,752246,344493,369099,213477,991497,531188,897408,392191,754169,663303,704123,684312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001862s ]