SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341050 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341050 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120819,347355,1004224,87236,70456,140399,844583,926858,345385,697977,1001227,406893,135156,168274,710975,423243,532276,942600,925391,586213,93480,732222,77400,77193,403725,467065,667986,823946,433848,469273,35608,259770,287580,897926,319770,836964,571339,591507,17510,252065,39107,361918,835321,703423,920351,367408,734455,696283,796030,634125,520735,559857,624056,275738,352367,360653,900924,705741,8777,356735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]