SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003745s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710943 LIMIT 1 [ RunTime:0.000751s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710943 [ RunTime:0.005027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894100,641422,900119,73611,241217,997487,59437,715477,585711,424276,690548,84282,657830,560850,63857,749205,263552,1037036,723605,520540,406568,553835,319282,290123,145226,1021698,244560,867516,264991,97257,399398,509721,766311,311136,561715,652168,1026359,91154,31249,815193,679825,208451,359740,690423,818880,711760,1036938,352866,540510,768683,611537,490544,217664,973450,445589,904395,810543,609310,960312,270223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]