SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281118 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281118 [ RunTime:0.003238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775072,204178,157385,440375,889739,464819,86812,889850,137682,780426,757685,417839,860126,232731,464591,974939,323753,1021868,874180,713431,860902,476328,649966,448108,531958,388009,70649,371099,114269,989250,631088,295535,570236,603700,443496,348590,993651,141537,641401,932309,953758,934709,60094,615743,49498,912028,983465,884762,42567,664392,593147,577356,1014936,604887,298808,895687,208209,133043,304152,802393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]