SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367311 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367311 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704660,757435,127992,739385,672356,766626,171506,338271,724071,288564,181403,112425,916444,616670,760643,222165,326303,979801,806179,449804,718513,801349,1038269,1011536,543724,464009,785002,1010620,557800,462593,934002,394736,467863,960933,778162,50135,630739,872144,1033369,714235,881340,976345,317491,431210,359970,319991,932337,268053,1042789,59182,957965,363560,1045780,975967,994439,846014,41849,720662,1028528,515033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]