SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020025 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020025 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475543,994964,213185,885624,820129,876467,872990,465121,397301,987890,673259,380951,935805,975248,559949,1016229,1025077,550287,612858,483118,301290,900504,390161,892614,428073,824002,364972,693399,920627,1003798,875590,239990,261745,1042955,400219,147265,702815,825737,264964,639643,673432,937905,755454,282367,49103,221794,672170,705729,835784,613905,345197,233602,1028834,683511,483912,205683,266184,897630,699948,762208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]