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` = 5447 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5447 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752482,19169,1000877,952788,328457,539743,594255,652191,1025657,527062,620468,20277,24300,848469,122874,1037179,951826,128848,93143,873793,656741,613505,870580,452608,514287,208219,479378,234653,924676,406747,957512,302361,547258,140999,401648,572732,817772,613854,351836,141386,395654,857634,68722,157966,275444,197854,668698,979695,881637,108629,694820,343085,230817,97175,803416,1029892,55843,1040536,884650,249989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001206s ]