SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49896 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49896 [ RunTime:0.002620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130310,145768,222094,274087,482918,612256,282084,873794,5687,544606,874989,767697,615942,510766,971143,561318,382010,525570,555574,181430,216515,390681,1035391,439523,12560,823762,294994,716537,918842,174406,989324,1030597,194321,66895,371302,861722,866385,985711,450434,392277,789783,876970,964952,45862,866869,609182,826832,282364,1033581,1014963,456824,492304,616728,578744,1024540,707416,594917,665701,877788,142976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]