SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545650 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545650 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499638,568773,1015331,824385,740282,718330,38410,852006,612498,64308,448271,733992,409282,413597,34830,63347,592757,900477,61326,520194,382818,13047,881813,788583,450440,985385,395668,977895,372135,298227,168237,29194,469522,806397,210162,708084,1020549,180351,298402,26531,833141,514643,217733,242185,758406,116393,378969,320340,899513,953207,538484,308615,243613,64498,673722,703437,662536,268253,790416,928295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]