SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503768 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503768 [ RunTime:0.002212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727354,80225,412457,759212,905442,556723,81952,133030,884579,180983,124449,819990,898936,547064,566971,994699,810112,670727,683525,437170,276200,909377,761801,192443,912480,638345,990976,686420,928524,772757,57691,362886,345705,971873,997093,1018971,683233,236556,623945,190140,171785,397296,591715,250669,819225,815857,214017,162945,74163,79599,570377,137866,946333,797028,960989,1032203,1034272,749734,742984,838472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503768 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503768 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]