SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002839s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519092 LIMIT 1 [ RunTime:0.001635s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519092 [ RunTime:0.002735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599349,237885,344752,769396,869390,781973,684485,919455,680808,679858,160605,366738,793916,610530,9758,940040,366901,728738,943800,345061,966847,897032,421713,647107,101649,719944,1037517,494023,598801,939661,497479,377186,474804,215820,12651,885077,743303,496779,700494,229468,43744,721240,403437,83103,167078,913856,712634,89998,26589,839830,2081,764093,682320,16481,245333,344520,877199,157574,414871,408773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001669s ]