SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305011 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305011 [ RunTime:0.003580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357023,881873,580815,763499,269908,58377,539080,833838,56220,1023741,290575,329290,285768,71586,20822,288359,572891,781344,870652,567233,226469,1044923,298855,267246,42340,282046,137011,304156,969350,714439,491074,300985,513871,407617,988313,520907,18887,106885,92230,835935,862291,204233,247888,341690,574911,175174,264218,1035104,803236,183256,671194,276271,647785,307947,342598,333844,673220,895329,625158,384608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005250s ]