SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300051 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300051 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734177,810593,449388,695212,635290,933605,1024716,271615,551583,644444,100109,978548,1022703,93742,533345,347523,538128,904243,608229,44795,785235,420393,138082,1001484,72397,381156,548899,38930,799551,262577,589814,184823,18381,780663,534167,170486,648172,36823,402918,741285,712542,714567,1027377,374620,304303,52260,905823,770052,42839,799011,539535,875613,964536,25711,105768,785556,360445,144327,702094,625873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000983s ]