SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103694 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103694 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69580,665531,514791,983659,252595,838551,104376,663293,59367,10605,734675,188479,231258,921917,65186,730683,726018,407427,83416,282252,288659,303459,536271,297710,848889,224036,991394,995903,333457,499679,184190,189873,622599,151504,287899,5579,787879,903138,107638,384031,396719,643560,196817,7938,496520,132494,481817,551562,722960,328312,542481,594582,482150,627338,896685,734944,556362,936668,8010,354956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]