SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529639 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529639 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184709,582780,518851,64924,345344,530646,444550,712046,680737,129080,525338,381754,659677,800069,261120,421190,698999,1031724,1048439,259439,510493,1027687,342936,208617,595296,427423,174253,60038,442248,588188,616169,884177,75307,259069,909315,352480,1038027,231496,471926,75032,1005206,286460,499182,819267,674792,534736,137048,491497,276924,607699,869847,576116,858326,869106,214222,480200,631964,288416,571018,40536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]