SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295340 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295340 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49759,954673,726583,534465,271904,422540,263612,684831,320979,377723,436293,542543,1001374,130289,269683,382823,932925,31536,497102,880954,443548,420751,535368,533125,560800,443656,26970,583955,36090,956313,481398,142626,906078,45467,628081,742506,777208,509590,731620,564399,175395,910426,238387,502457,327614,274751,733444,731930,288360,390985,45463,40968,702565,29108,1005011,125508,861532,740213,738155,752667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]