SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419040 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419040 [ RunTime:0.002835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857029,1019132,814499,267454,418343,324653,257302,537590,1280,300405,789268,936128,198045,467020,159007,43227,842796,526114,623300,242039,537996,507627,562986,363159,69905,231864,630152,1029686,71284,528342,376881,92234,480596,400484,44951,409979,269628,488127,542613,538195,100303,69120,777558,105466,649861,128654,731582,240061,605579,292873,90856,74009,388501,734591,444522,1032016,900740,992328,864137,67682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]