SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648899 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648899 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535313,1026037,68880,346571,979254,1008681,260961,413489,659708,828615,769690,588407,107377,401271,752927,56211,485279,189378,389800,1019578,834412,932352,790731,879408,126443,816548,842845,527742,217532,638827,52767,132112,925924,637233,47295,207675,766592,577462,691608,1025372,1036750,766833,268690,660087,31169,777394,308134,279502,229072,281876,535184,366194,744351,810641,722413,797831,21310,909855,130015,563808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]