SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458988 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458988 [ RunTime:0.002404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100206,361771,462208,734854,375656,267056,403039,814579,832100,801790,153802,926050,601341,511949,913912,37143,311126,287681,271259,582062,450307,196299,110200,110946,862516,857384,483243,355357,332676,382864,958807,612794,552837,221597,911183,922312,402944,806295,470987,476813,916348,628243,310024,200520,151487,408255,132766,390496,584867,117560,681850,401941,433436,917032,449599,27001,818895,384162,35026,328990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]