SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102571 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102571 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321959,426423,392233,917033,784543,519703,210832,780486,617975,222122,462771,520199,638338,428617,569839,851619,524539,232326,827541,765785,900988,27096,492160,264378,1036994,302504,638298,460648,448051,169707,909601,127543,436155,725560,756042,584830,849256,960977,41263,173354,495433,489080,175902,452374,928148,698408,732022,747321,344964,171761,992572,232753,54803,634531,860383,890102,456209,168192,539164,730037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]