SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339517 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339517 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144801,266740,258048,918060,580106,165832,826548,680295,677604,406870,316325,666807,682866,985187,608702,816988,800171,870972,911813,420784,671712,757856,987720,250018,685383,841883,897856,236712,276489,786355,131422,801947,989186,487801,112877,919340,890593,567586,467475,508292,248240,733654,589588,255528,837262,614372,782325,434134,965016,207161,377974,891048,1036915,775957,350429,566235,900486,242556,540303,310614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]