SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015131 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015131 [ RunTime:0.005139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046769,963747,606066,623607,334400,59786,73337,425157,258994,350925,589987,15664,209230,152399,647683,52464,233618,582812,30075,413071,922464,643543,703933,809471,215775,247835,841952,698298,768944,479930,344987,279939,373235,936446,838745,467752,873652,176733,1039738,149141,670289,808831,248211,438960,739236,871648,91266,836089,300849,14845,205162,918029,524913,389860,117242,874191,583698,843091,990505,578670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]