SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510650 LIMIT 1 [ RunTime:0.001215s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510650 [ RunTime:0.001355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122317,54654,460650,381307,112521,325379,180365,948962,443576,879486,318972,831733,215882,642652,730778,321735,30437,334936,174723,205378,311041,513202,557100,435470,467705,778290,153722,457878,106070,198419,468950,163485,556542,107826,542263,75319,959067,17122,1032739,170999,240722,228409,88502,963828,1035460,836870,772613,113303,427328,402653,274007,153923,704845,604267,406931,588747,781316,458277,629568,640323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000909s ]