SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260531 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260531 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556313,882858,1032454,704150,711612,333673,764919,244410,841484,38718,156033,581376,758405,962017,993146,352066,735605,530247,386788,245763,571512,908983,534463,568134,799788,769000,263992,518536,854549,950467,599765,236222,391442,413866,1032394,343756,1036897,499803,531575,796523,247106,195101,758863,586022,97255,233457,174499,603214,824514,795579,942135,165044,245308,937271,907753,160854,890836,888448,413412,541363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]