SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585180 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585180 [ RunTime:0.004799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930659,347547,603382,220305,74485,20397,453567,856313,634120,711595,975868,108618,127605,128924,830551,696873,449020,330351,801968,216740,739077,694552,389924,543274,300503,87701,285211,50594,50314,716991,850437,876540,965285,824116,659412,563888,612921,580440,207577,98678,95582,606643,682927,140125,195791,151679,211165,834553,565500,508630,1046327,296631,809749,257682,20375,1022008,752662,608297,1034815,677887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]