SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539042 LIMIT 1 [ RunTime:0.000624s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539042 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982880,701221,477827,942248,660328,710624,622880,301470,368831,590550,372537,308071,1033132,99046,419708,305871,540838,874914,176819,40664,778751,574056,120749,856970,966319,347313,409484,1041784,493556,726998,375904,305070,410206,190888,404089,407515,666800,914420,1016842,886389,254551,286887,434963,356318,148143,1013340,589878,745414,575034,848351,308572,42162,1041541,183022,728557,99715,524844,315926,138564,202422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]