SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046733 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046733 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609234,989811,219735,126110,695563,23986,522187,837502,677615,359031,60967,365124,942925,1005025,414721,386706,917281,987185,13179,301727,697568,17416,667747,268723,919548,56846,885296,959654,1002427,138738,604615,779749,300766,416398,220628,674273,190695,151407,389941,184013,882308,590123,256385,971725,574148,55478,456788,809019,550965,561687,600422,387714,127735,786737,1004262,1014513,758423,1003705,979143,76600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001810s ]