SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675913 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675913 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465895,746055,209704,943370,954571,862935,320075,879674,768539,136244,874495,1037409,923350,914398,231847,254647,825037,115415,655599,847178,466720,871823,146914,135337,882429,346223,910149,702524,224788,272162,97477,998420,1012558,280820,37801,916902,662572,944375,471678,641319,71500,658436,261257,107577,726742,518667,631998,817139,1038520,994014,319624,513945,423944,893459,755955,601691,591440,486080,883260,563828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000894s ]