SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533491 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533491 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19512,1039116,730961,301295,441160,928188,925765,125754,19177,854856,147089,537766,431013,812046,278963,315526,837492,735502,360554,576285,831641,95003,732711,1038063,77591,883816,512977,599667,262287,672440,11718,53196,729755,149463,417272,479190,359917,12838,983649,830123,141294,97468,597318,919011,1043718,282544,616681,754825,93350,321912,663437,195706,689481,355915,740018,609588,893002,556048,185574,335685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001992s ]