SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254120 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254120 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030175,182383,1026657,8270,288486,864375,591341,656517,87181,43467,1015046,897102,938214,661824,844742,944010,957632,796513,309268,100973,168656,351109,208700,686385,177360,340717,389745,939873,521062,90002,970072,999913,944469,213851,4529,992350,789077,362616,13743,327189,13725,779757,759005,651433,819063,507308,783213,796292,109789,868488,793337,525933,47632,45036,562545,73063,986952,65092,227084,791096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]