SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002928s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506571 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506571 [ RunTime:0.003481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134283,693698,559994,606511,174992,708658,608620,974253,716283,611605,173912,711594,377014,853425,1035123,5114,389120,912137,183266,943076,572097,694087,195938,974743,978167,137359,890992,172823,924462,540436,484387,691408,581794,797012,375171,24586,596552,23754,284128,819025,523812,1009884,480801,208738,547544,783207,108432,124250,797124,782402,224508,86500,612068,67097,818581,45986,777809,36303,584981,960136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]