SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038149 LIMIT 1 [ RunTime:0.005075s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038149 [ RunTime:0.007792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118146,840868,503344,362282,317068,955998,587959,244690,7888,579790,994430,783823,407699,692206,72839,685663,584250,733629,199681,784762,659681,240587,695152,709371,782700,494028,338950,616443,229460,774305,291158,992935,1002916,675007,658634,228152,762286,286193,746511,669423,102122,575705,1036998,211044,614142,92259,642193,793135,1021522,251218,76895,465848,88231,695851,546642,341900,779197,855988,455696,616803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006330s ]