SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107193 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107193 [ RunTime:0.002831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822779,16819,854237,705968,844843,426346,217649,440247,962215,410680,627920,1026417,938823,417519,198933,190772,535320,952941,55112,880890,20451,693700,712476,18035,490218,1026298,741877,201261,370568,943896,668653,1009200,201041,612702,580113,926683,1047082,512010,308913,166930,751749,93705,915216,852836,623863,877555,161600,486317,803540,732009,166480,110467,500359,40991,730045,496779,880536,300954,852974,62633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001656s ]