SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318372 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318372 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197475,952102,916116,422176,392513,346928,1025138,610002,250015,300823,449003,572935,89489,371266,330928,328779,891423,151561,1016554,686568,829098,699762,931935,64663,614918,17227,400318,844240,954705,778061,342246,108529,565699,183005,271253,837157,605791,595343,109621,235891,17058,461376,259143,194951,689919,549952,174195,91575,345181,109303,476150,658438,423181,437394,434100,80099,281519,455713,529166,479891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318372 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318372 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]