SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583685 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583685 [ RunTime:0.002397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767943,717878,260513,195371,479663,977906,131895,896822,322248,986778,855486,929926,987906,429522,34185,257879,630580,977422,105214,11652,545226,455366,70778,300837,352841,921046,664309,113392,873409,956897,448948,875664,746840,972843,449282,824021,122653,452185,270779,278495,735269,206806,45184,222450,158275,589397,907331,552470,279936,295306,888199,1045412,442422,763080,431622,514627,545706,883031,998160,472593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]