SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9910 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9910 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002110,266838,811501,164816,815150,98259,758806,377502,335880,22635,61528,105521,703601,727199,115642,176235,763092,78318,680723,403486,668517,357299,459583,883373,787340,709766,995933,255556,951885,177415,740471,725257,842448,983603,160109,327546,459715,175394,913720,213426,267066,485629,1026427,803801,103848,296934,317572,853407,41859,319504,1027726,823148,859609,93238,249817,126982,172798,280688,175704,905694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]