SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318876 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318876 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005370,142749,30473,1003275,446404,1042655,324425,22994,253,1002126,896714,51178,94218,558332,76534,702178,941001,187792,429752,537293,143277,186825,846095,257538,555790,167967,568582,153701,662113,11601,205566,889164,742926,958844,670785,448308,721621,634422,180129,845420,954749,826760,992440,460889,497411,378133,277683,606878,723311,362787,542042,258157,504578,740107,989512,560089,538110,531536,127796,108742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]