SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 762617 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 762617 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47308,803286,259653,299735,474098,250596,632906,66292,197862,630481,808017,945390,812094,287401,1005480,758753,75831,1037061,332077,767429,415848,548346,731601,372730,295245,57629,208488,860157,210524,591624,598699,464193,955490,183341,746350,304201,921172,1000562,232419,658638,902538,786789,559850,1015559,690445,239350,161761,1004312,16796,726458,2040,57191,323893,631791,636410,85182,402853,885076,322433,362473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 762617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 762617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]