SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 928596 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 928596 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042217,420985,674957,387808,901714,205711,943271,1023382,466423,235545,906590,431228,528914,278562,638515,757167,793236,1002399,202307,516048,991115,546137,377252,1006436,789471,150084,554099,183939,80861,956699,644852,584819,155740,754304,397351,961344,847993,304089,669294,971610,844254,943725,593725,960947,833074,698569,639488,963932,654193,533321,865785,974473,799738,956544,707080,716115,451828,624870,905107,831839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 928596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 928596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]