SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 350001 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 350001 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447695,324618,228765,550014,679130,36645,430953,638113,948073,420361,282252,883286,957407,572508,237123,15581,769996,124135,1037372,620237,611998,698879,357280,214558,765060,487624,137786,958327,43527,506384,74905,517897,816475,29117,500740,603476,10511,358022,202564,961581,662287,257147,654071,314190,17440,853871,527863,989315,1042927,637986,806673,177681,769291,1039990,604036,557778,981430,1017235,1020386,316713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 350001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 350001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]